Skip site navigation (1) Skip section navigation (2)

Re: order by different on mac vs linux

From: Wes James <comptekki(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: order by different on mac vs linux
Date: 2012-05-31 17:46:31
Message-ID: CAFjCMHvK0RJ=f-PYtmkvssGsPxVHtFE6qRWfqWHkjV0e7=fP1A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
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
> http://www.postgresql.org/docs/9.1/static/charset.html
>
>                        regards, tom lane
>

I did pg_dump of data, set LC_ALL=C, did initdb and createdb, pgsql -f
pgdump.sql db, etc, and now it is sorting the way I'd expect and for the
needs I have.

Thanks all for your responses.

-wes

In response to

pgsql-sql by date

Next:From: Peter EisentrautDate: 2012-05-31 19:52:39
Subject: Re: order by different on mac vs linux
Previous:From: lewblochDate: 2012-05-31 16:58:40
Subject: Re: Job control in sql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group