"... over grid buffer limit" Error

External Since: Dec 28, 2007 Posts: 3

Hi, I need to save a 6000-character-text data in a field. I see that length
of varchar is 8000. "The value you entered is not consistent with the
datatype orlength of the column, or over grid buffer limit" ! This is the
error message when ever I try to save. Could you please help me to find a way?

External Since: Mar 18, 2004 Posts: 317

> Hi, I need to save a 6000-character-text data in a field. I see that
> length
> of varchar is 8000. "The value you entered is not consistent with the
> datatype orlength of the column, or over grid buffer limit" ! This is the
> error message when ever I try to save. Could you please help me to find a
> way?

Are you talking about SQL Server or user interface error? If this is SQL
Server error, check whether you are using unicode (nvarchar) type - as every
character occupies 2 bytes in this type, it is limited to 4000 chars. If you
are talking about UI error, check the properties of your UI control.

--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/default.aspx