On 3 August 2016 at 20:36, Álvaro Hernández Tortosa <a...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
