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

Re: Case-Insensitve Text Comparison

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Case-Insensitve Text Comparison
Date: 2008-06-02 16:33:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
"David E. Wheeler" <david(at)kineticode(dot)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

In response to


pgsql-hackers by date

Next:From: David E. WheelerDate: 2008-06-02 16:45:27
Subject: Re: Case-Insensitve Text Comparison
Previous:From: Simon RiggsDate: 2008-06-02 16:29:17
Subject: Re: Overhauling GUCS

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