Storing large amounts of data as ntext data type |
 |
EXPERT RESPONSE FROM: Andrew Novick
|
|
|
|
| > |
QUESTION POSED ON: 11 August 2005
I am creating a Web site for a magazine with monthly data changes. I created a SQL Server table and specified the field as ntext data type to store large amounts of text data. When I try to input small amounts of data, it can be stored easily, but the larger data can not be stored. What can I do?
|
|
| > |
EXPERT RESPONSE
The column with the ntext data type can hold around 1,000,000,000 characters in each row. If you're having problems storing larger amounts of data, look at the other layers of your application. Is a variable limiting a smaller number of characters? Does the data access technology have some sort of limitation?
Do you have comments on this Ask the Expert Q&A? Let us know.
|
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
