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
