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

Поиск
Список
Период
Сортировка
От John Hansen
Тема Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32
Дата
Msg-id 5066E5A966339E42AA04BA10BA706AE5625C@rodrick.geeknet.com.au
обсуждение исходный текст
Ответы Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: jtv@xs4all.nl
Дата:
Сообщение: Re: Finding if old transactions are running...
Следующее
От: Jeff Davis
Дата:
Сообщение: idea for concurrent seqscans