Ensuring same collation on OSX and Linux? - Mailing list pgsql-general

From John Norman
Subject Ensuring same collation on OSX and Linux?
Date
Msg-id b6b8b6b71001221309m2977da98v214709256c8f6db3@mail.gmail.com
Whole thread Raw
Responses Re: Ensuring same collation on OSX and Linux?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I observe that with the apparently same locale settings on OSX and
Linux (stock Ubuntu 9.10), that the collations are different.

Here's my sample query:

select name from (
    select 'A' as name
        union
    select 'a' as name
) tab
order by name asc

OSX: LC_COLLATE="en_US.UTF-8"
Result:

name
A
a

Linux: LC_COLLATE="en_US.UTF-8"

name
a
A

Also, I note that this is system-wide. If I sort a text file with
contents of A and a on separate lines . . . using /usr/bin/sort . . .
I get the same result.

Maybe the UTF8 collations on OSX (or Linux) are broken?

John

pgsql-general by date:

Previous
From: "Bob Pawley"
Date:
Subject: Re: Old/New
Next
From: "Informatica-Cooperativa Cnel. Oviedo"
Date:
Subject: Sugerencia de opcion