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 05:36:48
Message-ID: 3DEE0501-D904-427D-8F5C-3CF9231AEE0E@kineticode.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Jun 1, 2008, at 22:18, Tom Lane wrote:

>> I'm using C. Of course you're correct that it depends on the  
>> locale, I
>> always forget that. But does not the Unicode standard offer up some
>> sort locale-independent case-insensitivity, so that it gets it right
>> some large percentage of the time?
>
> Not really, and in any case the C locale completely disables any
> knowledge of Unicode.  C locale knows about 7-bit ASCII and nothing
> more.

And the locale can only be set by initdb?

I don't suppose that there are any collations that sort and index case- 
insensitively, are there? I don't see anything suggestive in `locale - 
a`…

Thanks,

David

In response to

pgsql-hackers by date

Next:From: David E. WheelerDate: 2008-06-02 05:37:26
Subject: Re: Case-Insensitve Text Comparison
Previous:From: Tom LaneDate: 2008-06-02 05:27:23
Subject: Re: Overhauling GUCS

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