Re: Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars
Дата
Msg-id 2999.1022383504@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars  (pgsql-bugs@postgresql.org)
Список pgsql-bugs
Henry House <hajhouse@houseag.com> writes:
>> Unfortunately you didn't mention anything about your locale setup...

> The server locale is en_US.UTF-8. (At least I set it up as such when
> installing PostgreSQL; I know no way to verify.) The server version is 7.2.=
> 1,
> running on a IA32 and a DEC Alpha; both machines show the same behavior. Bo=
> th
> are Debian Linux. Perhaps the bug lies in the locale definition supplied by
> Debian?

Offhand I'd not necessarily expect an en_US locale to upcase/downcase
anything except a-z/A-Z.  Perhaps you need to use a different locale.

I'd suggest taking this up with a locale expert, which I surely am
not.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug #676: lower(), upper(), & initcap() do not work on utf-8 chars
Следующее
От: Caspar Bothmer
Дата:
Сообщение: bug in documentation