AW: 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.

There is a feature in the upcoming PostgreSQL 12 release that

allows for accent insensitive queries:

https://www.postgresql.org/docs/12/collation.html#COLLATION-NONDETERMINISTIC

This is part of PostgreSQL’s support for ICU collations.

Thanks,

Jonathan