Subject Re: [firebird-support] How to store all char (#0 for exemple) in OCTET char column
Author Mark Rotteveel
On 10-1-2012 14:17, Vander Clock Stephane wrote:
> Hello,
> How, via SQL text can i store bytes (that include for exemple #0, #1,
> etc..) in OCTETS char column ?
> Var char(16) i m happy i have for exemple
> CHAR_TO_UUID()<langrefupd25-intfunc-char_to_uuid.html> and
> UUID_TO_CHAR()<langrefupd25-intfunc-uuid_to_char.html>
> for for other length ?

Depending on your access library, you could simply use parametrized
queries and supply an array of bytes. Otherwise you would need to look
at the OCTETS escape introduced in - I believe - 2.5: x'<hexadecimal
pairs' eg x'CAFEBABE':

Mark Rotteveel