Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
1023 char limit??
Message
From
02/08/2005 13:27:40
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01037907
Message ID:
01037923
Views:
23
>>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?
Thank You

Rollin Burr

Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform