| From: | raf <raf(at)raf(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: help understanding collation order |
| Date: | 2011-01-19 02:34:43 |
| Message-ID: | 20110119023443.GA25805@raf.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Peter Eisentraut wrote:
> On tis, 2011-01-18 at 10:33 +1100, raf wrote:
> > p.s. if anyone in debian locale land is listening,
> > 'E' does not sort before ','. what were you thinking? :-)
>
> What is actually happening is that the punctuation is sorted in a second
> pass after the letters. Which is both correct according to the relevant
> standards and also practical in many situations.
i have no doubt that what you say is true just as i have no doubt that
it is also incorrect and impractical in every situation i'll ever encounter.
i can't imagine ever wanting CLARK to sort both before and after CLARKE.
i'll just re-sort all name-ordered reports in the client. pity.
> It's usually actually the Mac OS X locales that are broken.
only when ignoring the principle of least astonishment. :-)
but it's not the same locale on the two hosts. the macosx
locale is en_AU. the debian locale is en_AU.utf8 so i don't
think they can be compared for brokenness purposes in this case.
they may both be correct.
cheers,
raf
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ozz Nixon | 2011-01-19 03:06:07 | Another table/column has semi-current COUNTs? |
| Previous Message | Alban Hertroys | 2011-01-19 00:04:02 | Re: Getting a sample data set. |