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
