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 по дате отправления: