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

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