News for hackers. Stuff that matters.
Re:Ask HN: It's 2023, how do you choose between MySQL and Po... by dijit on Thursday May 11, 2023 @04:51PM (#35908208)
Maybe this helps: https://stackoverflow.com/posts/11007216/revisions ?

My gut tells me that I would do it in the query itself though, and not rely on the collation. Maybe I am misunderstanding.

Re:Ask HN: It's 2023, how do you choose between MySQL and Po... by sjamaan on Friday May 12, 2023 @03:44AM (#35913204)
Look under "Update for Postgres 12 or later", there they create a collation, an index to make use of it and then a query to make use of it:

   SELECT \* FROM users WHERE name = 'João' COLLATE ignore_accent;