On Mon, May 14, 2012 at 5:00 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
I'll take a look.
In response to
pgsql-sql by date
|Next:||From: Wes James||Date: 2012-05-15 15:39:45|
|Subject: Re: order by different on mac vs linux|
|Previous:||From: Misa Simic||Date: 2012-05-15 12:21:56|
|Subject: Re: SELECT 1st field|