Dear Group
I admit, this might be a very ignorant question.
BOL says about the ntext data type:
Variable-length Unicode data with a maximum length of 2^30 - 1
(1,073,741,823) characters.
I've stored a string consisting of around 45.000 characters in a ntext
field - done by copying the string in my txt document and pasting in
Enterprise Manager.
When I determine the datalength of the field in SQL Analyzer I get
2046.
Is this realistic? Is it bytes or the actual number of characters? It
seems incrrect to me..
Although, when I read the string with a DataReader based on a stored
procedure and save it in a string variable in my VB.NET application,
the string is truncated, although the variable can hold up to
approximately 2 billion Unicode characters according to MSDN.
I just wonder whether I've done something wrong or misunderstood
something on the SQL server side that causes this problem.
Thanks very much for your help!
Martin