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