Re: (7.1) BIT datatype

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/