The following bug has been logged on the website:
Bug reference: 9722
Logged by: Martin Vassilev
Email address: mv@netsurf.bg
PostgreSQL version: 9.3.4
Operating system: Linux Slackware x86_64
Description:
test1=# \d test1
Table "public.test1"
Column | Type | Modifiers
--------+---------+------------------------------------------------------
ID | integer | not null default nextval('"test1_ID_seq"'::regclass)
TEXT | text |
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.
I want to thanks pgsql team for great work on this DB project.
regards,
Martin