Ensuring same collation on OSX and Linux?
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
John Norman <john@7fff.com> writes:
I observe that with the apparently same locale settings on OSX and
Linux (stock Ubuntu 9.10), that the collations are different.
...
Maybe the UTF8 collations on OSX (or Linux) are broken?
Yeah, OS X's support for UTF8 locales is pretty broken :-(. You
can find previous discussions about that in the PG archives --- there
was one just a few days ago.
regards, tom lane