Peter Geoghegan on Twitter: "@moikmeg Not accent-insensitive. It's hard to do this, even though ICU supports it, for historical reasons. Hopefully this will be fixed soon. See https://t.co/Pqf9rC0TYS if you want to know the full details. For now, maybe try citext." / Twitter

hi, do you know if PostgreSQL has a collation that is both case-sensitive and accent-insensitive? Thanks

Replying to

Not accent-insensitive. It's hard to do this, even though ICU supports it, for historical reasons. Hopefully this will be fixed soon. See postgresql.org/message-id/CAJ if you want to know the full details. For now, maybe try citext.

6:03 PM · Mar 23, 2018Twitter Web Client

Replying to

thanks for your answer

Conversation