How to add line breaks in a query (Informix)?

Question

I need to do a query that updates text with a line break. I tried using \n but it inserts "\n" literally.

Example:

update table set text = "first line\nsecond line"

I want it to show that text as:

"first line
second line"

and not as "first line\nsecond line".

When I do this with .NET it works, but not on a stored procedure.

Does anyone know how to do this?

Answer 1

You might, perhaps, be looking for the function 'ifx_allow_newline'.

Alternatively, following the suggestion of OMG Ponies, you might be looking for the package 'ascii' from the IIUG Software Archive. Informix now has the functions ASCII() and CHR() built-in. Note that if you have older versions of Informix (anything before 11.50 — 11.70 for CHR()), these functions will not be available and you will need to consider the package from the IIUG archive.