Re: Sorting Problem in UNICODE/german

On Thu, Sep 01, 2005 at 09:30:15AM -0400, Tom Lane wrote:
> Klaus Ita <postgres@stro.at> writes:
> > I have tried starting postgres with LC_ALL=de_AT.utf8@euro
> > locale but that did not help.
>

i did read the docs and am still not quite happy with my sorting results.
ok initdb has been rerun

made sure, i had the locale:

locale -a

created new db-cluster with
LC_ALL=de_AT.utf8@euro initdb --locale=de_AT.utf8@euro -E UNICODE -D /dev/shm/pgutf8

and then still the sorting was not right when i restored another UNICODE db.

another "funny" thing is:

ita@aipc54:~/.mutt$ LC_ALL=de_AT.utf8@euro sort /tmp/testfile
Abend
Oma
Ãterreich
Ãerflieger
Unter
Zetrix

this is also wrong (There should be 'Unter' and then 'U:berflieger' [Überflieger]). so is this a libc bug?


thank you for your help so far! I more than appreciate it. Support for this
DB is sooo much better than for oracle!

klaus