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 <lan@xxxxxxxxxxxx> 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@xxxxxxxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
--
alexander lunyov
lan@xxxxxxxxxxxx