Thread: 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"

On Tue, 2013-11-19 at 19:49 +0000, oleg_ispu@mail.ru wrote:
> 1. select 'English' ilike '%en%'=20
> 2. select '=D0=A0=D1=83=D1=81=D1=81=D0=BA=D0=B8=D0=B9' ilike '%=D1=80=D1=
=83%'
>=20
>=20
> First case true, second - false.

Works for me.  Make sure your lc_ctype setting is set to something
reasonable, not 'C'.