Re: CR-LF in char/varchar column

smurthy@netgravity.com (Sunil Murthy) wrote: :It seems that when I pass an insert SQL into a char or varchar :column and the column value has Carriage Return Line Feed, :Informix returns a -282 error : :INSERT INTO t1 (col1) VALUES ('Hi, :This is a test of CR-LF on Informix :Sunil') : :# ^ :# 282: Found a quote for which there is no matching quote. :# : :Works fine on other databases. Any work around ? :Informix 7.20 OWS, ESQL/C 7.20 :We are actually using Roguewave db access library and passing straight :SQL using their sqlExecute. The only workaround I know of is to put your quoted string into a variable and inserting that. That allways works fine. Be carefull though whether you need a CR-LF or only an LF depending on where and how you use the data. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org