--- In firebird-support@yahoogroups.com, "M Tuttle \(KS\)"
<miket@s...> wrote:

> Greetings All,
>
> I know you cannot directly insert a text blob with a SQL insert script.

I assume you are using IB, right?
This lack of functionality was addressed since Firebird v1. Server may
consume more memory than expected but I think this was solved in newer
versions (v1.5 or v2, not sure).

> But
> I seem to remember running across a UDF that would allow this to happen.
> Can anyone tell me where to find this UDF? Or how they are using insert
> script to insert data that contains text blobs?

If you don't want to use isql, you can always use your own program
that prepares the statements and goes in a loop feeding the parameters
and executing the statement. Preparing once is much faster.
But if you run scripts with isql and you use IB or don't want to use
FB's automatic feature to insert or update blobs with literal text,
you can resort to fbudf's string2blob or freeUdfLib that also has a
function for that.

C.