Re: russian case-insensitive regexp search not working

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: russian case-insensitive regexp search not working
Дата
Msg-id 18790.1184075693@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: russian case-insensitive regexp search not working  (alexander lunyov <lan@startatom.ru>)
Ответы Re: russian case-insensitive regexp search not working  (alexander lunyov <lan@startatom.ru>)
Список pgsql-general
alexander lunyov <lan@startatom.ru> writes:
>     With this i just wanted to say that lower() doesn't work at all on
> russian unicode characters,

In that case you're using the wrong locale (ie, not russian unicode).
Check "show lc_ctype".

Or [ checks back in thread... ] maybe you're using the wrong operating
system.  Not so long ago FreeBSD didn't have Unicode locale support at
all; I'm not sure if 6.2 has that problem but it is worth checking.
Does it work for you to do case-insensitive russian comparisons in
"grep", for instance?

            regards, tom lane

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

Предыдущее
От: "Alexander Staubo"
Дата:
Сообщение: Re: TOAST, large objects and ACIDity
Следующее
От: Brad Nicholson
Дата:
Сообщение: Vaccum Stalling