Hi Christian,

Christian Gütter <news@g...> wrote:

> does this really work for you?

Yes, just modify and compile api3.c in the 'examples'
directory.

> When I try the following query with FB 1.5:
>
> SELECT '123' || '\x0d\x0a' || '456' FROM RDB$DATABASE
>
> I get the following result:
>
> 123\x0d\x0a456
>
> So the '\x0d\x0a' ist not treated as CR/LF.

How are you trying this? It only works in C, as the
C compiler does the substitution of '\x0d\x0a' to the
two bytes CR/LF. You can't test this in ISQL and you would
need another escaping mechanism in Delphi, I guess.

Regards,
Peter Jacobi