Re: Sorting Problem in UNICODE/german

On Thu, Sep 01, 2005 at 09:30:15AM -0400, Tom Lane wrote:
> Klaus Ita <postgres(at)stro(dot)at> writes:
> > I have tried starting postgres with LC_ALL=de_AT(dot)utf8(at)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(dot)utf8(at)euro initdb --locale=de_AT(dot)utf8(at)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(at)aipc54:~/.mutt$ LC_ALL=de_AT(dot)utf8(at)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