Re: Variable Length Character Data > 256 bytes

Need more info. Which version of ODBC are running? What is the client, ie, Windows? Steve Romankiw Grant Hickey wrote: > I need to create a column in a informix table that will allow me to store at > least 2000 bytes of variable length character data that I can insert a > literal into , update and search on the column. I working on an ODBC client > application using SQL. A Text datatype will allow me to store the > information but will not allow me insert, update or delete using SQL. I can > use a char(2000) but then I am using 2000 bytes everytime. I have tried > using lvarchar in my SQL create table statement but am getting a syntax > error. > > Any help would be appreciated > > Grant Hickey > North Plains Systems -- Steve Romankiw Chubb / Executive Risk 82 Hopmeadow Street Simsbury, CT 06070