Hi Dorin,

--- In firebird-support@yahoogroups.com, "Dorin Pacurar" <dopa@z...>
wrote:

> > MY_TEXT = 'Hello' || '\x0d\x0a' || 'world';
> >
> > or simply MY_TEXT = 'Hello\x0d\x0aworld';
>
> Instead of adding a crlf in my text variable added 'x0d\x0a'
> Ex: I need something like this:
> OldID: 1000 -> NewId: 1001
> OldIx: 12 -> NewIx: 23
> What I get:
> OldID: 1000 -> NewId: 1001\x0d\x0aOldIx: 12 -> NewIx: 23

What is your programming enmvironment? You must use the character
escaping of your programming language. \x0d\x0a will work in C (and
C++, Python, etc).

Peter