Re: HELP: Informix 5, Varchar / Char types / Powerbuilder 4

Hans Nieuwenburg wrote: > > 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 > ____________________________________________________________Sound like the engine still thinks the column type is varchar and not char. Check syscolumns for the data type ("coltype, collength"). I guess you could unload the table then drop the table and re-create it with the column as char(4096) which is a big column. Why not define it as a text column? Hope this helps Clyde