Re: data needs string length > 256 characters

Li Su wrote: > I'm using informix dynamic server 7.30 on NT4.0 > > I defined type char(4000) for a table column. This is the situation: > > 1. The create table was successful. > 2. insert statement when I inserted string which length is less than > 256 was successful. > 3. insert statement got: SQL error (-280): a quoted string exceeds > 256 bytes > > What's the problem here? How can I insert a string which length is > longer than 256? > > Is there any other data type allowed to use insert statement to insert > longer string? Using DB-Access or ISQL, you're stuck. Using ESQL/C or I4GL or other programming tool, you use a host variable to contain the data, and write the INSERT statement with a placeholder (a question mark) in place of a literal, and then supply the host variable in the USING list when you execute the statement. Or you can use LOAD to insert values. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>