Re: Yet another problem with ILIKE and UTF-8 - Mailing list pgsql-bugs

From Gregory Stark
Subject Re: Yet another problem with ILIKE and UTF-8
Date
Msg-id 87ve8vth0j.fsf@oxford.xeocode.com
Whole thread Raw
In response to Yet another problem with ILIKE and UTF-8  ("Gergely Bor" <borg42@gmail.com>)
Responses Re: Yet another problem with ILIKE and UTF-8
Re: Yet another problem with ILIKE and UTF-8
List pgsql-bugs
"Gergely Bor" <borg42@gmail.com> writes:

> I have a nasty-looking problem case. Shortly described as follows:
>
> INSERT INTO mytable (id, value) VALUES (4242, '=FAabcd=FA');
> SELECT id FROM mytable WHERE value ILIKE '%abc%';
>
> In environment A, the row of the ID just inserted is returned
> correctly, but in environment B no rows are found. Uh! (Sadly
> environment B is the productive environment... :/)
>
> Notice the UTF-8 chars in the inserted sting and the _lack_ of UTF-8
> chars in the searched string.
>
> Environment A: Win2000, psql 8.2.4, lc_* is C, all encondings (client,
> server, DB) are UTF-8.
> Environment B: Debian lenny/sid ^[1], kernel version 2.6.20.1, glibc
> 2.6.1-5, psql 8.2.5, lc_* is hu_HU, all encondings (client, server,
> DB) are UTF-8.

I'm not sure this is the right answer but what happens if you initdb a
database on the Debian box with lc_* set to hu_HU.UTF-8 ?=20
(You may have to add it to /etc/locale.gen and rerun locale-gen)

Also, what does lower('=FAabcd=FA') return in that locale?=20

--=20
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: "Pierre-yves Strub"
Date:
Subject: BUG #3696: FK integrity check bypassed using rules.
Next
From: Tom Lane
Date:
Subject: Re: BUG #3695: Pgsql does not report non existing function