From: Peter Eisentraut <peter_e@gmx.net>
To: Wes James <comptekki@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: order by different on mac vs linux
Date: Thu, 31 May 2012 22:52:39 +0300
Message-ID: <1338493959.22408.27.camel@vanquo.pezone.net> (raw)
In-Reply-To: <CAFjCMHtp94sxvG3U86pwaCVcXEtiyDWAgsFOag6=WFoyinpYeQ@mail.gmail.com>
References: <CAFjCMHse4AHdTav96ifSsKaqq1Ggj43Xc=DPBfwCzZyuYKAJFQ@mail.gmail.com>
<CAFjCMHtp94sxvG3U86pwaCVcXEtiyDWAgsFOag6=WFoyinpYeQ@mail.gmail.com>
On lör, 2012-05-26 at 21:47 -0600, Wes James wrote:
> on the ascii table here:
>
> http://www.ascii-code.com/
>
> upper case letters should sort before lowercase letters.
ASCII has nothing to do with how letters "should" be sorted. It is not
a sorting standard, it is a character encoding standard. If you open a
dictionary, you won't (usually) find all upper case letters before all
lower case letters.
The sort orders provided by glibc are, individual bugs aside, correct,
where "correct" means, they implement various national and international
standards. (Equally, the sort orders on Mac OS X are, degenerate cases
aside, broken, because they don't implement any recognized sorting
standard.) Of course, you are not required to like them, and there are
many people who have particular issues with them, but you won't get far
claiming they are wrong, if you don't have a recognized alternative
source to point to that defines correctness.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: peter_e@gmx.net, comptekki@gmail.com
Subject: Re: order by different on mac vs linux
In-Reply-To: <1338493959.22408.27.camel@vanquo.pezone.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox