BUG #8607: ilike operator
The following bug has been logged on the website:
Bug reference: 8607
Logged by: Oleg
Email address: oleg_ispu@mail.ru
PostgreSQL version: 9.3.1
Operating system: CentOS release 6.4 (Final)
Description:
1. select 'English' ilike '%en%'
2. select 'Русский' ilike '%ру%'
First case true, second - false.
"PostgreSQL 9.3.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-3), 64-bit"
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Tue, 2013-11-19 at 19:49 +0000, oleg_ispu@mail.ru wrote:
1. select 'English' ilike '%en%'
2. select 'Русский' ilike '%ру%'First case true, second - false.
Works for me. Make sure your lc_ctype setting is set to something
reasonable, not 'C'.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs