Re: Sorting Problem in UNICODE/german

From: Andreas Seltenreich <andreas+pg(at)gate450(dot)dyndns(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Sorting Problem in UNICODE/german
Date: 2005-09-02 09:56:49
Message-ID: 87k6hz23oe.fsf@gate450.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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:
>>
>> 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?

I think I got your point now. Libc appears to be using iso-14651
sorting for all "de" locales. I'm afraid you will have compile a
customized locale to depart from that.

regards,
Andreas
--

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Viswanath Ramineni 2005-09-02 14:13:34 BUG #1860: Insert failed due to unique index
Previous Message Andreas Seltenreich 2005-09-02 07:54:39 Re: Sorting Problem in UNICODE/german