Re: About upper() and lower to handle multibyte char

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Weiping <laser(at)qmail(dot)zhengmai(dot)net(dot)cn>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: About upper() and lower to handle multibyte char
Date: 2004-10-19 15:05:36
Message-ID: 15961.1098198336@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Weiping <laser(at)qmail(dot)zhengmai(dot)net(dot)cn> writes:
> we have a database which encoding is UNICODE,
> when we do queries like:
> select upper(''); --select some multibyte character,
> then postgresql response:

> ERROR: invalid multibyte character for locale

What locale did you initdb in? The most likely explanation for this
is that the LC_CTYPE setting is not unicode-compatible.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eric E 2004-10-19 15:19:05 Sequence question
Previous Message Hicham G. Elmongui 2004-10-19 14:56:44 code in docs gives me an error