Обсуждение: Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32

Поиск
Список
Период
Сортировка

Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32

От
"John Hansen"
Дата:
> John Hansen wrote:
> > currently, upper/lower does not work with 2+ byte unicode
> characters,
> > on any OS under the C locale.
>
> Sure it does.  It's just that the defined behavior of the C
> locale is often useless in practice.

select upper('æøå');
ERROR:  invalid multibyte character for locale
HINT:  The server's LC_CTYPE locale is probably incompatible with the database encoding.

Consequently it seems that is does not work.

... John

Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32

От
Tom Lane
Дата:
"John Hansen" <john@geeknet.com.au> writes:
>> Sure it does.  It's just that the defined behavior of the C
>> locale is often useless in practice.

> select upper('æøå');
> ERROR:  invalid multibyte character for locale
> HINT:  The server's LC_CTYPE locale is probably incompatible with the database encoding.

> Consequently it seems that is does not work.

"It fails on my machine" should not be read as "it doesn't work for anyone".
It all depends on how your local mbstowcs() works.

            regards, tom lane