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
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 |
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 ... |