one of my fields in my database tables is of the data type NVARCHAR(4000).
I assign this field to be of the maximum length as I need to store text strings of various lengths
and some of these strings may contain characters like an 'e' with a stroke above (I do not know what you call that
I imported some data into the table and for the field of data type NVARCHAR(4000), the text information was
truncated at the 1000th character (inclusive of spaces). When I tried to enter some data directly into the field
using Enterprise Manager, I am unable to do so.
I hope someone can shed some light on this issue.