I'm trying to cut and paste about 2000 characters of html into a Sql Server table. When I do so, only the first 300 or so characters get pasted and a dialog box pops up with the following message:

The value you entered is not consistent with the data type or length of the column, or over grid buffer limit.

The datatype for the field I'm pasting the html into is varchar and the length is set to 8000.

ALSO, when I insert a lot of text (approximately 2000 characters) into the database the "normal" way (via the website using a textbox, button, ado.net objects, and stored procedures) the following exception is returned:

Error: Cannot create a row of size 8597 which is greater than the allowable maximum of 8060. The statement has been terminated.

Are these errors related?

I'm using MSDE (stripped down version of SQL Server that comes with VS.NET). Does MSDE limit the amount of data you can put in each cell?

Does setting the length of a field to 8000 mean 8000 characters can be placed in that field or something else?

Is varchar the right datatype to be using for lengthy data?

Answers to any of the above would be most appreciated.

Thanks!

Daniel

The row size has some limitations there. Add up the size of all the other fields in your table and see that doesnot exceed 8060 as the error shows. As you say this particular field is given as varchar(8000) then the remianing fields of a row should count for the remaining 60 bytes. Better you can reduce the size of this varchar(8000) to varchar(4000) or a lesser size that could suit your requirement and not be given more than what you could actually paste to the maximum. Or you can try with TEXT datatype. I am not sure about its size, but that might help you resolve this. See to that the total size of the row does not exceed 8060.

It all depends on how optimised you manage the fieldsize.

Hope that helps.

_________________________
-Vijay G
Strive for Perfection