Subject Re: [firebird-support] Binary representation without parameters
Author Alexandre Benson Smith
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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil