thanks the x' fit perfectly my need

On 1/10/2012 11:03 PM, Mark Rotteveel wrote:
>
> 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
>
>


[Non-text portions of this message have been removed]