Subject Re: [firebird-support] Inserting Blobs in SQL scripts
Author Scott Morgan
Stefan Heymann wrote:
> I expect the answer to be NO, but I want to try anyway (Firebird
> has its surprises from time to time):
>
> Is there a way to insert Blob data via a script command. Something
> like a way to insert a base64 string as a blob?
>
> INSERT INTO MYTABLE (ID, BLOBFIELD) VALUES (1, <base64 here>);
>
> Is that possible?

The FSQL[0] script utility can load data into a blob from external files.

Something like (IIRC):

INSERT INTO MYTABLE (ID, BLOBFIELD) VALUES (1, @'myfile.b64');

Scott

[0] http://www.volny.cz/iprenosil/interbase/fsql.htm