From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wes James <comptekki@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: order by different on mac vs linux
Date: Mon, 14 May 2012 19:00:10 -0400
Message-ID: <23053.1337036410@sss.pgh.pa.us> (raw)
In-Reply-To: <CAFjCMHse4AHdTav96ifSsKaqq1Ggj43Xc=DPBfwCzZyuYKAJFQ@mail.gmail.com>
References: <CAFjCMHse4AHdTav96ifSsKaqq1Ggj43Xc=DPBfwCzZyuYKAJFQ@mail.gmail.com>
Wes James <comptekki@gmail.com> writes:
> Why is there a different order on the different platforms.
This is not exactly unusual. You should first check to see if
lc_collate is set differently in the two installations --- but even if
it's the same, there are often platform-specific interpretations of
the sorting rules. (Not to mention that OS X is flat out broken when
it comes to sorting UTF8 data ...)
If you want consistent cross-platform results, "C" locale will get
that for you, but it's pretty stupid about non-ASCII characters.
For more info read
http://www.postgresql.org/docs/9.1/static/charset.html
regards, tom lane
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: tgl@sss.pgh.pa.us, comptekki@gmail.com
Subject: Re: order by different on mac vs linux
In-Reply-To: <23053.1337036410@sss.pgh.pa.us>
* 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