At 08:22 AM 20/03/2007, you wrote:

>hello everyone!
>
>i have still problems when trying to execute an
>INSERT statement to a blob.
>
>i have txts that are more bigger than 16 kb,
>i tried to do
>
>INSERT INTO my table (MYBLOBfield)values (here i copy
>pasted my txt bigger than 16kb)
>
>some people has recommend me to use params and
>prepare method, but it also doesnt work.
>
>i really need help on this, because i have to
>migrate a mysql table into firebird but i cant
>load blob fields.
>
>thanks in advance for your help

Did you know that a blob is not a string? It is just a "soup" of
bytes, from the point of view of the database engine.

You don't say what "problems" you have. Tell us about the exceptions
you are encountering. If they are in Portuguese, provide the 9-digit
gdscode as well.

You *can* present a string as literal input to a TEXT (sub_type 1)
blob but you are limited to string length of 32,765 BYTES. If the
incoming text from your MySQL database is multi-byte (Unicode, or
some other multi-byte encoding) then it is quite possible that the
string is longer than the 32 Kb string limit.

Tip :: Use a proper datapump tool, that does the right thing with blob data.

./heLen