Re: Inserting special caracters in a table

"Dynabec / Developpement" <developpement@dynabec.com> wrote: :Hi, : I'ld like to know if someone know how to load a cariage return and line :feed caracter in a table. Using insert statement. : :If somebody have an answer, please let me know. : :You can send me e-mail at : developpement@dynabec.com : :Thank a lot ! As allways it's realy impossible to answer a question of how to use a tool when that tool is not named. I don't know of a way to do this via interactive sql (using dbaccess or similar tools). However if you are using some programming language you simply put your data into a variable (string/char) and insert that. We have done that for years, and it works fine. The char datatype (on a database column) may not be supposed to contain such characters, but it generally works to put any character except 0 hex into such a column. 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