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

From Martijn van Oosterhout
Subject Re: ilike and utf-8
Date
Msg-id 20060414134747.GA5676@svana.org
Whole thread Raw
In response to ilike and utf-8  ("Raphael Bauduin" <rblists@gmail.com>)
Responses Re: ilike and utf-8
Re: ilike and utf-8
List pgsql-general
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?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: export from views
Next
From: "Tomi NA"
Date:
Subject: Re: ilike and utf-8