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

From David E. Wheeler
Subject Re: Case-Insensitve Text Comparison
Date
Msg-id 3DEE0501-D904-427D-8F5C-3CF9231AEE0E@kineticode.com
Whole thread Raw
In response to Re: Case-Insensitve Text Comparison  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Case-Insensitve Text Comparison
Next
From: "David E. Wheeler"
Date:
Subject: Re: Case-Insensitve Text Comparison