Re: ilike and utf-8 - Mailing list pgsql-general

From Tomi NA
Subject Re: ilike and utf-8
Date
Msg-id d487eb8e0604140833w154e7560k43ce34de543d65c9@mail.gmail.com
Whole thread Raw
In response to Re: ilike and utf-8  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general

On 4/14/06, Martijn van Oosterhout <kleptog@svana.org> wrote:
On Fri, Apr 14, 2006 at 03:16:01PM +0200, Raphael Bauduin wrote:
> Hi,
>
> Does the ilike operator work fine with cyrillic text put in a UTF-8
> encoded database?
> I've had remarks of a user (of http://myowndb.com, a web database)
> with text in cyrillic that his searches are not case insensitive,
> although I use the ilke operator in the code. And it works perfectly
> for my data (that are not in cyrillic).

UTF-8 support for case-comparison is operatnig system dependant. What
systems are we comparing here?

I'd like to know the same thing. I'm using GNU/linux and ISO-8859-2 (when UTF-8 isn't an option).

Tomislav

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: ilike and utf-8
Next
From: Tom Lane
Date:
Subject: Re: corrupted item pointer:???