Re: order by different on mac vs linux

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wes James <comptekki(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: order by different on mac vs linux
Date: 2012-05-14 23:00:10
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-sql

Wes James <comptekki(at)gmail(dot)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

regards, tom lane

In response to


Browse pgsql-sql by date

  From Date Subject
Next Message Jan Bakuwel 2012-05-15 06:01:34 SELECT 1st field
Previous Message Wes James 2012-05-14 22:42:05 order by different on mac vs linux