Subject Re: [firebird-support] Re: Newlines etc. in string literals
Author Helen Borrie
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? rings a bell...which version of ib_udf are you using? That
particular UDF got bug-fixed for Firebird.

Even LONGER ago, I recall Bill Karwin giving his foolproof method to the
Mers list - in particular, this was for outputting newline or cr/lf at the
end of a row being written to an external file. He recommended storing any
non-printable characters in their own table and literally copy-and-pasting
them from a suitable text file. Then query them out as required and write
into the column.

>Actually I've used this approach before when inserting graphics into
>BLOB fields via a generated script that reads the graphics from
>files. For that I wrote a UDF that takes a base64 encoded string and
>returns a BLOB. Any interest in including base64 codec UDFs into
>fb_udf? I've got the decoding part working already.

Well - propose it on firebird-devel. :-)