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
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 |