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