Re: lower does not handle german umlaut

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: lower does not handle german umlaut
Дата
Msg-id 5109.1005153136@sss.pgh.pa.us
обсуждение исходный текст
Ответ на lower does not handle german umlaut  (Peter Pilsl <pilsl@goldfisch.at>)
Ответы Re: lower does not handle german umlaut
Список pgsql-general
Peter Pilsl <pilsl@goldfisch.at> writes:
> If I perform a select lower() on uppercased german umlauts, these wont be
> converted to lowercase.

AFAIK this should work if (a) the system was built with --enable-locale
and (b) you are running it in an appropriate locale setting.  The
SQL lower() function just invokes the C library's tolower() conversion
routine, so if it doesn't work your beef is with tolower() ...

            regards, tom lane

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

Предыдущее
От: Jean-Michel POURE
Дата:
Сообщение: Re: functions, shell script
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance Question Followup No.2