Nicolaus Erichsen <nico(dot)erichsen(at)hsh-berlin(dot)com> writes:
> I recently found a problem with sorting german 'Umlaute' .
Sounds like you did not set the right locale when creating the database.
You need to be careful to run initdb with LANG (or LC_ALL or at least
LC_COLLATE) set to what you want, probably "de_DE".
> All this happens with a database created with encoding ='latin1'.
Encoding is not the issue, locale is.
regards, tom lane