Jono,
I don't know whether you are trying to insert directly from isql or
is embedded. You may try to assign the binanry data into a variable
and put an indicator to indicate what it is.

Peter

--- In firebird-support@yahoogroups.com, "Jonathan Hull" <jono@f...>
wrote:

> Hi all,
> The following query works:
>
> insert into my_table (name_id, name_value) values

('1', 'o''mally');

>
> and will insert the name o'mally into the name_value field where
> name_value is a BLOB. However it does not work when binary data

is in

> the statement. In MySQL and PostGreSQL a backslash (\) character

can

> be added in the SQL statement before apostrophy ('), before quote

(")

> and before null (chr(0)), and this works fine in those databases to
> add binary to a blob field directly in SQL. Is there is similar
> syntax for FireBird?
>
> Cheers,
> Jono