Ensuring same collation on OSX and Linux?

[John Norman <john@xxxxxxxx>]

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general