russian case-insensitive regexp search not working

From: alexander lunyov <lan(at)startatom(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: russian case-insensitive regexp search not working
Date: 2007-07-09 10:06:34
Message-ID: 469208AA.9000601@startatom.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(at)startatom(dot)ru

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wouter Gazendam 2007-07-09 11:39:44 Re: How to obtain a sequence's increment value from the system catalog
Previous Message Ragnar 2007-07-09 09:49:11 Re: Database Insertion commitment

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Kreen 2007-07-09 10:24:43 Re: Threaded Python on BSD ...
Previous Message Hans-Juergen Schoenig 2007-07-09 09:51:48 Threaded Python on BSD ...