Discussion:
"... over grid buffer limit" Error
(too old to reply)
Jocobo81
2007-12-28 15:31:02 UTC
Permalink
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?
Dejan Sarka
2007-12-29 07:38:40 UTC
Permalink
Post by Jocobo81
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
Jocobo81
2007-12-29 08:39:00 UTC
Permalink
I use SQL Server 2000 Enterprise Manager without any other program. In a
table I have 2 fields: one text and the other is varchar. Neither of them can
I write a data which is longer then 1000 character. I write as example
:"12345678901234567890123...."
Post by Dejan Sarka
Post by Jocobo81
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
Jocobo81
2007-12-29 08:50:00 UTC
Permalink
I can write Max 1024 characters
Post by Dejan Sarka
Post by Jocobo81
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
Loading...