The Informix 5 varchar type can onle be 255 characters long while the char
type can be mutch longer. In a database we first had a vanchar field and
converted that to char to enlarge the field to 4096, somehow the database
comes back with an error when we try to insert a record with text longer
then 255 characters the message we get is: -280
This is the meaning of -280 from the informix help file:
"-280
A quoted string exceeds 256 bytes.
Somewhere in this statement there is a character literal that exceeds the
maximum allowed. Inspect the statement, checking the punctuation and
length of all quoted strings. Possibly two quotes are missing, making a
long string out of two short ones. If you intended to use a string of
this length, you will have to revise the statement. There is no means for
writing such a long character string in an SQL statement.
"
How can we solve this, according to the table configuration this field is
4096 bytes long!
Please HELP! (i'm in despere)
Thanks,
Hans Nieuwenburg
____________________________________________________________
message from : Hans.Nieuwenburg@cmg.nl
\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/
\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/\\/
DataBases | Programming | Optimizing | DocumentManagement | WorkFlow
____________________________________________________________
CMG Finance | Laan van Kronenburg 14 | 1183 AS Amstelveen
Tel : 020-5033000
____________________________________________________________