Horton

Re: How well does PostgreSQL 9.6.1 support unicode?

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: James Zhou <james@360data.ca>
Cc: Vick Khera <vivek@khera.org>, pgsql-general <pgsql-general@postgresql.org>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Date: 2016-12-21T23:56:45Z
Lists: pgsql-general 
James Zhou <james@360data.ca> writes:
> The format U&'\03B1' only works for chars between 0000 - FFFF

Kyotaro-san already pointed you to the right answer on that:
you have to use "\+nnnnnn" for six-digit code points in the U&
string syntax.

			regards, tom lane

Commits

  1. Fix detection of unfinished Unicode surrogate pair at end of string.