Does PostgreSQL support “accent insensitive” collations?
Update for Postgres 12 or later Postgres 12 adds nondeterministic ICU collations, enabling case-insensitive and accent-insensitive grouping and ordering. The manual: ICU locales can only be used if support for ICU was configured when PostgreSQL was built. If so, this works for you: CREATE COLLATION ignore_accent (provider = icu, locale=”und-u-ks-level1-kc-true”, deterministic = false); CREATE INDEX … Read more