Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #8607: ilike operator - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #8607: ilike operator
Date
Msg-id 1385211493.13910.0.camel@vanquo.pezone.net
Whole thread Raw
In response to BUG #8607: ilike operator  (oleg_ispu@mail.ru)
List pgsql-bugs
Tree view 
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'.

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #8610: Duplicate records with same PK value
Next
From: Peter Eisentraut
Date:
Subject: Re: pgdump not dumping my database