PostgreSQL, Mac OS X and locales

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