10 pages data in single column

Posted on 2005-04-21
Last Modified: 2010-04-17
im working on database app, using & ms sql server, in some of my tables there is one column for "Notes" this column could be upto 10 full pages of text, my first question is wheather its appropriate to use (text) datatype for this column, since im not sure using (text) datatype wont slow down the system when having load of database ......
futhermore i need to use (ms word) like capabilities for that column in dataforms, and whatever user wrote in this column save into sqlserver table column "Notes" instead saving as file.
simply this (ms word) like textbox must have databindings with database table's column "Notes"

thanks ...

Question by:nauman32
    1 Comment
    LVL 19

    Accepted Solution

    My suggestion to you would be: Use NText data type. If you also expect binary data, consider VARBinary or BLOB data type. If I remember correctly, Text data type can't store over 8000 characters.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Javascript: Crash Course

    Javascript is not only emerging as the most important language to know, it's flexibility is unique. With Javascript being deployed on the web, mobile and even the desktop this is the one language that all technologists need to know.

    Suggested Solutions

    Title # Comments Views Activity
    Windows 10 SmartScreen vs ClickOnce app 5 88
    matchUp  challenge 6 34
    countClumps  challenge 10 66
    scoresAverage challenge 8 58
    Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
    If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now