Ritchie Annand wrote:

> Is there a way to encode binary data in a text format for submitting
> to Firebird?
>
> I'm experimenting with a CHAR(16) column with OCTETS, and it seems to
> work just jolly well for retrieving binary data and for updating
> binary data with parameters, but I can't seem to find a way to
> represent the raw binary data such that I can, say, put it into a SQL
> statement in a tool. A number of other databases represent the raw
> data with a hex prefix (e.g. 0x) or have a RAW type that takes
> hexadecimal values directly (Oracle does this).
>
>
>

...

> Is there a way of representing raw binary (which could include zeroes)
> as text to send to Firebird?
>
> Cheers,
>
> -- Ritchie Annand
>
>

I think it will be available in future versions, but don't know if on
2.1 or not (I don't think so)

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br