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