Subject | Re: [firebird-support] Inserting Blobs in SQL scripts |
---|---|
Author | Scott Morgan |
Post date | 2008-10-10T13:07:56Z |
Stefan Heymann wrote:
Something like (IIRC):
INSERT INTO MYTABLE (ID, BLOBFIELD) VALUES (1, @'myfile.b64');
Scott
[0] http://www.volny.cz/iprenosil/interbase/fsql.htm
> I expect the answer to be NO, but I want to try anyway (FirebirdThe FSQL[0] script utility can load data into a blob from external files.
> 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?
Something like (IIRC):
INSERT INTO MYTABLE (ID, BLOBFIELD) VALUES (1, @'myfile.b64');
Scott
[0] http://www.volny.cz/iprenosil/interbase/fsql.htm