Re: Putting carriage returns into varchar field

Hi all. In Informix 9.x you can do the following: EXECUTE PROCEDURE ifx_allow_newline( 't' ); INSERT INTO foobar VALUES ( '1 23 4' ); I don't know offhand whether you can do this with 7.x and 8.x as well. Hope this helps. Regards, Johann Tienhaara Platform Engineering Informix Software Ireland, Ltd. Sujit.Pal@bankofamerica.com wrote: > > Donald > > You would either need to use TEXT datatype (which may be a lot more work > depending on your programming language and how far you are in the development > process) which supports \\r\\n or \\n in the string, or you need to do a little > more work when inserting the VARCHAR to the database and selecting it back from > the database. What you need to do is to parse your string before it is inserted > to the database, looking for [\\r]\\n and replace them with a "special" string and > on the way out parse for the special string and replace with [\\r]\\n. With web > apps it is easy, we need to parse only on the way in and replace with <BR>, and > when displaying to the browser it automatically evaluates to a linefeed. > > HTH > Sujit > > Donald Kunecke <donald.kunecke@wcom.com> on 12/15/99 10:42:26 AM > > Please respond to Donald Kunecke <donald.kunecke@wcom.com> > > To: informix-list@iiug.org > cc: (bcc: Sujit Pal) > Subject: Putting carriage returns into varchar field > > I am trying to put carriage returns into a varchar field for data that is to > be sent to a report writer. The max length of the data is 255, and probably > has between 1 and 8 carriage returns. If I strip the c/r's off, I can get > the record in, but, I really do need the c/r's for the report writer. > > Any help much appreciated.