Re: [BUGS] Sorting Problem in UNICODE/german

2005-09-02 Thread Tom Lane
Andreas Seltenreich <[EMAIL PROTECTED]> writes: >> Klaus Ita schrob: >>> this is also wrong (There should be 'Unter' and then 'U:berflieger' >>> [Überflieger]). so is this a libc bug? > I think I got your point now. Libc appears to be using iso-14651 > sorting for all "de" locales. I'm afraid you

Re: [BUGS] Sorting Problem in UNICODE/german

2005-09-02 Thread Andreas Seltenreich
Sorry, I just reread your mail: Your MUA is declaring it with > Content-Type: text/plain; charset=unknown-8bit This makes it even harder to discuss problems with Umlauts :-). Andreas Seltenreich schrob: > Klaus Ita schrob: > >> another "funny" thing is: >> >> [EMAIL PROTECTED]:~/.mutt$ [EMAIL

Re: [BUGS] Sorting Problem in UNICODE/german

2005-09-02 Thread Andreas Seltenreich
Klaus Ita schrob: > On Thu, Sep 01, 2005 at 09:30:15AM -0400, Tom Lane wrote: >> Klaus Ita <[EMAIL PROTECTED]> writes: >> > I have tried starting postgres with [EMAIL PROTECTED] >> > locale but that did not help. >> > > i did read the docs and am still not quite happy with my sorting results. > o

Re: [BUGS] Sorting Problem in UNICODE/german

2005-09-01 Thread Klaus Ita
On Thu, Sep 01, 2005 at 09:30:15AM -0400, Tom Lane wrote: > Klaus Ita <[EMAIL PROTECTED]> writes: > > I have tried starting postgres with [EMAIL PROTECTED] > > 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

Re: [BUGS] Sorting Problem in UNICODE/german

2005-09-01 Thread Tom Lane
Klaus Ita <[EMAIL PROTECTED]> writes: > I have tried starting postgres with [EMAIL PROTECTED] > locale but that did not help. You need to run initdb under that setting. See "Localization" in the documentation. regards, tom lane ---(end of broadcas