char length

[rhull]

I need to store a block of data into a char field.
The data may have up to 2000 chars. The char field can go up to 32k but when i send it the data i get a 280 error saying "string literal to long" (ie past 256) How do I send it the data if I wont take a string literal? (DB wont allow BLOB spaces)

Any ideas?
Thanks
-Ryan

 

[Efim]

This is a know bug of informix. If the data that you need to insert is static (i.e. does not get changed by a program) you can load the data with LOAD command. Else you are out of luck - either use BLOBs or have several CHAR columns 255 characters each and deal with breaking the text and collecting it back.