Re: Case-Insensitve Text Comparison - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Case-Insensitve Text Comparison
Date
Msg-id 19957.1212424410@sss.pgh.pa.us
Whole thread Raw
In response to Re: Case-Insensitve Text Comparison  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: Case-Insensitve Text Comparison  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
"David E. Wheeler" <david@kineticode.com> writes:
> On Jun 1, 2008, at 21:08, Tom Lane wrote:
>> [ broken record... ]  Kinda depends on your locale.  However,  
>> tolower()
>> is 100% guaranteed not to work for multibyte encodings, so citext is
>> quite useless if you're using UTF8.  This is fixable, no doubt, but
>> it's not fixed in the project as it stands.

> Would the use of str_tolower() in formatting.c fix that?

Yeah, you need something equivalent to that.  I think that whole area
is due for refactoring, though --- we've got kind of a weird collection
of upper/lower/initcap APIs spread through a couple of different files.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Overhauling GUCS
Next
From: Chris Browne
Date:
Subject: Re: Core team statement on replication in PostgreSQL