Re: BUG #2554: ILIKE operator works incorrectly - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2554: ILIKE operator works incorrectly
Date
Msg-id 27292.1154645929@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #2554: ILIKE operator works incorrectly  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Peter Eisentraut <peter_e@gmx.net> writes:
> JarosÅaw Bojar wrote:
>> ILIKE operator works incorrectly with UTF8 encoding and Polish
>> characters.

> What does SHOW lc_collate say?

Even if the locale is set right, iwchareq() is completely broken
for multibyte charsets: it's trying to apply the system's tolower()
to a pg_wchar, which is highly unlikely to work.  This has been a
known problem for awhile, but no one's stepped up to fix it.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #2554: ILIKE operator works incorrectly
Next
From: "Nikolay Samokhvalov"
Date:
Subject: Fwd: Strange behaviour of RULE (selecting last inserted ID of 'sequenced' column)