Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


10 pages data in single column

Posted on 2005-04-21
Medium Priority
Last Modified: 2010-04-17
im working on database app, using vb.net & 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

RanjeetRain earned 2000 total points
ID: 13832440
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.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

571 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