Re: German "umlaut insensitive" query

On Sep 20, 2019, at 4:36 AM, <Jakob.Witczak@dlr.de> <Jakob.Witczak@dlr.de> wrote:

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

 

I also found this article:

https://dba.stackexchange.com/questions/195502/postgres-collate-example-in-select

 

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.