On Mon, May 14, 2012 at 5:00 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Wes James <compte...@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
I checked both and they both say this: show lc_collate; lc_collate ------------- en_US.UTF-8 (1 row) You mention OS X is broken, but it looks like the linux box is broken in this case. With the current database I have, it looks like everything is sorting correctly on both platforms, except those two records (the two lines from my first email) which I added later for testing characters and escaping, etc. on a web app. -wes -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
