Re: russian case-insensitive regexp search not working

No, ILIKE also does case-sensitive search.

I found this bug report:
http://archives.postgresql.org/pgsql-bugs/2006-09/msg00065.php

Is it about this issue? And will it be fixed someday?

Sergey Levchenko wrote:
> Just use: select street from people where street ILIKE 'зелен%';
> 
> select with case-insensitive regexp does no work right now!
> 
> On 09/07/07, alexander lunyov  wrote:
>> 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
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>>

-- 
alexander lunyov
lan@startatom.ru