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':
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-hexbinstrings.html




--
Mark Rotteveel