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

From David E. Wheeler
Subject Re: Case-Insensitve Text Comparison
Date
Msg-id EC2BF19A-C839-485F-8324-996A26788914@kineticode.com
Whole thread Raw
In response to Re: Case-Insensitve Text Comparison  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Case-Insensitve Text Comparison  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Jun 1, 2008, at 21:08, Tom Lane wrote:

>> 1. Does the use of the tolower() C function in the citext data type  
>> on
>> pgfoundry basically give me the same results as using lower() in my
>> SQL has for all these years?
>
> [ 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?

Thanks,

David


pgsql-hackers by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Proposal: new function array_init
Next
From: Greg Smith
Date:
Subject: Re: Overhauling GUCS