Oliver Elphick writes:
> Some SQL92 functionality is missing from the BIT and VARBIT types.
>
> It should be possible to enter hexadecimal values as:
>
> B'[<bit>...]'[{<separator>...'[<bit...]'}...]
> X'[<hexdigit>...]'[{<separator>...'[<hexdigit...]'}...]
>
> (Cannan and Otten: SQL - The Standard Handbook, p.38)
>
> but the hexadeximal form is not accepted.
This was omitted because in SQL99 the X'1001' notation also serves as a
binary large object value under certain circumstances. Unfortunately,
it's not exactly known what those circumstances are.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/