Postgres Pro
Downloads
Home   >   mailing lists

Re: About upper() and lower to handle multibyte char - Mailing list pgsql-general

From Tom Lane
Subject Re: About upper() and lower to handle multibyte char
Date
Msg-id 15961.1098198336@sss.pgh.pa.us
Whole thread Raw
In response to About upper() and lower to handle multibyte char  (Weiping <laser@qmail.zhengmai.net.cn>)
Responses Re: About upper() and lower to handle multibyte char
List pgsql-general
Tree view 
Weiping <laser@qmail.zhengmai.net.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

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: clustering
Next
From: "Hicham G. Elmongui"
Date:
Subject: code in docs gives me an error