AW: German "umlaut insensitive" query

Thanks for the quick answer. I am looking forward to the new PostgresSQL version. Thanks

Jakob

Von: Jonathan S. Katz [mailto:jonathan(dot)katz(at)excoventures(dot)com]
Gesendet: Freitag, 20. September 2019 14:17
An: Witczak, Jakob
Cc: pgsql-sql(at)postgresql(dot)org
Betreff: Re: German "umlaut insensitive" query

On Sep 20, 2019, at 4:36 AM, <Jakob(dot)Witczak(at)dlr(dot)de> <Jakob(dot)Witczak(at)dlr(dot)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> 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-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