Re: Implementing full UTF-8 support (aka supporting 0x00) - Mailing list pgsql-hackers

On 03/08/16 21:42, Geoff Winkless wrote:
> On 3 August 2016 at 20:36, Álvaro Hernández Tortosa <aht@8kdata.com> wrote:
>>      Isn't the correct syntax something like:
>>
>> select E'\uc080', U&'\c080';
>>
>> ?
>>
>>      It is a single character, 16 bit unicode sequence (see
>> https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html).
> No, what you've done there is created the three-byte utf8 sequence \xec8280
>
> # select U&'\c080'::bytea;
>    bytea
> ----------
>   \xec8280
>
> It's not a UCS2 c080, it's utf8 c080.
>
> Geoff
    Yes, you're absolutely right ^_^
    Álvaro


-- 

Álvaro Hernández Tortosa


-----------
8Kdata