PostgreSQL, Mac OS X and locales

[Guido Neitzer <guido.neitzer@xxxxxxxxxxxxx>]

Hi.

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.

As an example, I get:

a
b
ä

where it should be:

a
ä
b

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?

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

Attachment: smime.p7s
Description: S/MIME cryptographic signature