Subject Re: [firebird-support] BLOBs and SQL
Author Ann W. Harrison
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?
Milan Babuskov wrote:
>>And where do we get that "binary BLOB data" from in the first place? You
>>mean, you wish to enter it as a string?
Jason Dodson wrote:
> 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]);

The short answer is no, there is no such notation currently. I'm
not sure that using blobs for values under a couple of hundred bytes
long is very efficient, but the same issue arises around strings of
bytes going into octet type character and varchar strings.

Does anyone know off hand how the SQL standard suggests passing
binary byte arrays?