russian case-insensitive regexp search not working

Поиск
Список
Период
Сортировка
От alexander lunyov
Тема russian case-insensitive regexp search not working
Дата
Msg-id 469208AA.9000601@startatom.ru
обсуждение исходный текст
Список pgsql-general
Hello, friends.

OS FreeBSD 6.2, Postgresql 8.2.4

Postgresql does not search case-insensitive russian regexp unicode
patterns. Postgres is working under user pgsql with login class (in
/etc/login.conf):

postgres:\
     :lang=ru_RU.UTF-8:\
     :setenv=LC_COLLATE=C:\
     :tc=default:

In .profile of postgres user:

LANG=ru_RU.UTF-8
export LANG
CHARSET=UTF-8
export CHARSET

Then, database:

db=> \encoding
UTF8

Case insensitive search for low-cased pattern show nothing:

db=> select street from people where street ~* 'зелен';
  street
--------
(0 rows)

While there are records, but they are with first capital character:

db=> select street from people where street ~* 'Зелен';
      street
----------------
  Зеленая
  Зеленоградская
(2 rows)

Search for english values work fine, russian values not. Why could it be?

--
alexander lunyov
lan@startatom.ru


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

Предыдущее
От: Ragnar
Дата:
Сообщение: Re: Database Insertion commitment
Следующее
От: "Wouter Gazendam"
Дата:
Сообщение: Re: How to obtain a sequence's increment value from the system catalog