On 03/08/16 21:31, Geoff Winkless wrote:
On 3 August 2016 at 20:13, Álvaro Hernández Tortosa <a...@8kdata.com> wrote:
Yet they are accepted by Postgres
(like if Postgres would support Modified UTF-8 intentionally). The caracter
in psql does not render as a nul but as this symbol: "삀".
Not accepted as valid utf8:
# select E'\xc0\x80';
ERROR: invalid byte sequence for encoding "UTF8": 0xc0 0x80
You would need a "modified utf8" encoding, I think.
Geoff
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).
Álvaro
--
Álvaro Hernández Tortosa
-----------
8Kdata
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
