| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David E. Wheeler | 2008-06-02 05:37:26 | Re: Case-Insensitve Text Comparison |
| Previous Message | Tom Lane | 2008-06-02 05:27:23 | Re: Overhauling GUCS |