Skip site navigation (1) Skip section navigation (2)

Re: Case-Insensitve Text Comparison

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Case-Insensitve Text Comparison
Date: 2008-06-02 16:13:55
Message-ID: EC2BF19A-C839-485F-8324-996A26788914@kineticode.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-hackers by date

Next:From: Greg SmithDate: 2008-06-02 16:22:21
Subject: Re: Overhauling GUCS
Previous:From: Pavel StehuleDate: 2008-06-02 16:03:06
Subject: Proposal: new function array_init

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group