0

I would like to find a way to eliminate the accents of a string in postgresql. For exemple, 'aaéeeà' should become 'aaeeea'.

any ideas ?

thank you for your answers, have a great day

best regards

Armand Violle
  • 42
  • 6
  • 2
    You can [install](https://www.postgresql.org/docs/current/sql-createextension.html) the [unaccent](https://www.postgresql.org/docs/current/unaccent.html) extension and use the `unaccent()` function –  Aug 19 '21 at 08:17
  • both of your suggestions with ```unaccent()``` work for me, thank you for your asnwers, have a nice day! – Armand Violle Aug 19 '21 at 08:25

0 Answers0