Issues with german 'Umlaute'

Hello everybody,

I recently found a problem with sorting german 'Umlaute' . I hope the encoding
of this mail works ;-) :

Postgres puts Umlaute (i.e., ￜￜￜￜￜￜ) at the very end of the Alphabet, and
this is not the way it should be. I didn't check for the special Character
'ￜ', but its probably similar.

The canonical sort order for Umlaute is to treat them as two characters, like
this:
ￜ -> ae
ￜ -> oe
ￜ -> ue
ￜ -> ss
( and the same for upper case 'ￜￜￜ'. 'ￜ' does not have an upper case )

Well, I guess this might be difficult to implement and might have quite an
impact on performance. The solution I know from other databases consists of
inserting ￜ after a, ￜ after o, ￜ after u and ￜ after s. Afaik this is
generally accepted.

upper() does not handle Umlaute correctly as well. It leaves ￜￜￜ unchanged
instead of converting them to upper case.

All this happens with a database created with encoding ='latin1'. If there
are better results with a different encoding (I didn't try it yet), I'd
suggest adding some information about this in the documentation.

Thanks for your work,

N.Erichsen

--
HSH Soft-und Hardware Vertriebs GmbH
Rudolf-Diesel-Straï¿œe 2 - 16321 Lindenberg
Tel. (030) 94004 - 509 Fax (030) 94004 - 400