[GENERAL] PostgreSQL, Mac OS X and locales

[Guido Neitzer]

Hi.




As an example, I get:

a
b
ä

where it should be:

a
ä
b





I'm using the following configuration:

- Mac OS X (Server) 10.4.x and 10.3.x
- PostgreSQL 8.0.3
- initdb with encoding set to UTF-8 or ISO-Latin-1 (same results)

Some hints? Thank you!

cug

I have a problem with the use of PostgreSQL on Mac OS X (10.4.x) and selects with "order by". When there are german umlauts in the column which is used to order, the sorted result is wrong. Had someone here the same problem and solved it? I think the locales, that come with Mac OS X are broken for this, as it seems they don't provide the correct LC_COLLATE sort order. I tried to figure out, how to get a correct LC_COLLATE file but wasn't successful so far. Someone else?

smime.p7s
Description: S/MIME cryptographic signature