German "umlaut insensitive" query

Hi,

i found an entry from 2004, where it is about the German Umlaute and i have
the same problem.

<https://www.postgresql.org/message-id/4135E7F5.4070002%40stroetgen.de>
https://www.postgresql.org/message-id/4135E7F5.4070002%40stroetgen.de

I also found this article:

<https://dba.stackexchange.com/questions/195502/postgres-collate-example-in-
select>
https://dba.stackexchange.com/questions/195502/postgres-collate-example-in-s
elect

Are there other possibilities today (for example COLLATE) besides replace()
to process the German Umlaute?

In the long term, we also want to use it for other countries.

Best Regards

Jakob Witczak

————————————————————————

Deutsches Zentrum für Luft- und Raumfahrt e.V. (DLR)

Institut für Luft- und Raumfahrtmedizin | Abteilung für Luft- und
Raumfahrtpsychologie | Sportallee 54a | 22335 Hamburg

P.-Jakob Witczak | Dipl.-Ing.(FH)

Telefon 040 513096-845 | <mailto:jakob(dot)witczak(at)dlr(dot)de> jakob(dot)witczak(at)dlr(dot)de

<http://www.dlr.de/> DLR.de