Re: Sorting Problem in UNICODE/german

Andreas Seltenreich <andreas+pg(at)gate450(dot)dyndns(dot)org> 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 will have compile a
> customized locale to depart from that.

I wouldn't call it a libc bug, but a bug in the locale definition.
In any case it doesn't appear to be Postgres' problem --- if we sort
the same way "sort" does under the same locale setting, then we are
doing what we expect.

I think at this point Klaus needs to find some people who know about
hacking locale definitions. I sure don't know enough about them to
help further. Is there a libc mailing list anywhere?

One thing I do know --- if you install a new version of the locale
Postgres is using, you'd better re-initdb, or at least REINDEX all
your indexes on textual columns. Changing sort order is equivalent
to making such indexes corrupt.

regards, tom lane