Re: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic

mv@netsurf.bg writes:
> test1=# select * from test1 where "TEXT" ilike 'Тест%';
>  ID |     TEXT
> ----+---------------
>   3 | Тестов запис
>   4 | Тестов запис1
> (2 rows)

> test1=# select * from test1 where "TEXT" ilike 'тест%';
>  ID | TEXT
> ----+------
> (0 rows)

> Тhese two queries should return the same result.
> I don't had that problem in version 8.4.X.

Perhaps you don't have the database locale/encoding set correctly?
(Look at the lc_collate and lc_ctype settings, and compare to what
you were using in 8.4.)

Another possibility is that you changed machines and the new OS
doesn't have the right Cyrillic locale definition.  PG mostly depends
on the OS' locale features to implement things like case folding.

            regards, tom lane