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.

Any Ideas??