Subject Re: [firebird-support] BLOBs and SQL
Author Jason Dodson
Ultimately, this is what I wish to learn to do (may not necessarily use it. But
for now, I would like to know the possibilities).

I was thinking maybe there was some special notation to delimit binary data,
perhaps something like:

Insert Into MyTable (ID, MyBlob) Values (1, [00FF00C1C1FF0FF0FF00]);


Milan Babuskov wrote:
> Jason Dodson wrote:
>> Is there some magical means of getting binary BLOB data into a BLOB with a
>> simple insert statement? Maybe something like BINHEX?
> And where do we get that "binary BLOB data" from in the first place? You
> mean, you wish to enter it as a string? Something like:
> insert into t1 (blob1) values (BLOB('0ab6e842'));
> ?

The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.