Subject Re: Newlines etc. in string literals
Author malte_starostik
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> At 01:10 PM 7/08/2003 +0000, you wrote:
>
> >Although I needed to use 'blah'||substr(aschii_char(13),1,1)
||substr
> >(ascii_char(10),1,1)||'blah' or it would truncate anything after
the
> >first ascii_char(). Is this a known issue?
>
> Hmmm...it rings a bell...which version of ib_udf are you using?
That
> particular UDF got bug-fixed for Firebird.

The one that came with the FB 1.5 RC4 Linux superserver build.
Double checked and that's definately the one and only ib_udf.so on
the server box. According to webcvs, aschii_char() never changed
since the initial import. The ib_udf.sql used to build the database
in question is also current.
From looking at it, the implementation appears correct to me, but
then I never spent too much time working with UDFs that return
strings.

Regards,
-Malte