Re: About upper() and lower to handle multibyte char
От
Tom Lane
Тема
Re: About upper() and lower to handle multibyte char
Дата
Msg-id
15961.1098198336@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
About upper() and lower to handle multibyte char Weiping <laser@qmail.zhengmai.net.cn>
Re: About upper() and lower to handle multibyte char Tom Lane <tgl@sss.pgh.pa.us>
Re: About upper() and lower to handle multibyte char Weiping <laser@qmail.zhengmai.net.cn>
Re: About upper() and lower to handle multibyte char Weiping <laser@qmail.zhengmai.net.cn>
Weiping 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 по дате отправления
