Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
1023 char limit??
Message
 
 
To
02/08/2005 13:27:40
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01037907
Message ID:
01037925
Views:
15
>>>I have created a document table with a field 'comments', a varchar(7000) field. The table has few other fields, all of which total less than 7500 (i.e. it is not over the 8080 limit). When I go into Word and create an entry, then try to cut and paste it into the table (through enterprise manager), it does not respond, or rather it responds as if I have pasted an empty string.
>>>
>>>I cut and pasted one line at a time, and it took up to a point. In one line, it would no longer paste, so I started typing by hand. When I got to 1023 characters, the field would not take any more letters.
>>>
>>>I pasted the Word entry into a text editor to remove any possible formatting or hidden problems. There was no difference.
>>>
>>>I then went into the same field and tried to type in data. I was only able to enter 1023 letters.
>>>
>>>I do not understand, since this is a 7000 char field.
>>
>>It's Enterprise Manager limitation. You should use other means to populate longer fields .
>
>Where can I look for documentation of this limitation?

I've no idea. I found it the same way you did.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform