Re: How well does PostgreSQL 9.6.1 support unicode?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James Zhou <james(at)360data(dot)ca>
Cc: Vick Khera <vivek(at)khera(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Subject: Re: How well does PostgreSQL 9.6.1 support unicode?
Date: 2016-12-21 23:56:45
Message-ID: 18493.1482364605@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

James Zhou <james(at)360data(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message neos 2016-12-22 00:16:59 Re: Too long startup time after each crash.
Previous Message Adrian Klaver 2016-12-21 23:43:14 Re: error updating a tuple after promoting a standby