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

From: mv(at)netsurf(dot)bg
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic
Date: 2014-03-25 13:03:16
Message-ID: 20140325130316.13982.32775@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 9722
Logged by: Martin Vassilev
Email address: mv(at)netsurf(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2014-03-25 14:21:15 Re: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic
Previous Message postgresql 2014-03-25 11:59:30 BUG #9721: Fatal error on startup: no free slots in PMChildFlags array