Josef Kokeš wrote:

> I am trying to convert a BLOB (unlimited size, theoretically) to a long
> VARCHAR (say, VARCHAR(8192)). This should be easy enough to do:
>
> DECLARE VARIABLE b BLOB; /* input */

Which subtype of BLOB? IIRC, BLOB subtype 1 (text) should support
character sets, so you don't have to lose non-ASCII characters.

If it's a binary blob (subtype 0) you can also try to dump the contents
to a file (using FBExport or your code) and then import it back into a
new subtype 1 blob.

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================