BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic
| От | mv@netsurf.bg |
|---|---|
| Тема | BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic |
| Дата | |
| Msg-id | 20140325130316.13982.32775@wrigleys.postgresql.org обсуждение |
| Ответы |
Re: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic
|
| Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: