unaccent: Getting rid of umlauts, accents and special characters

PHOTO EMBED

Mon Aug 21 2023 20:21:16 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

test=# SELECT unaccent('Hans-Jürgen Schönig, Gröhrmühlgasse 26, Wiener Neustadt');
                        unaccent                         
---------------------------------------------------------
 Hans-Jurgen Schonig, Grohrmuhlgasse 26, Wiener Neustadt
(1 row)

test=# SELECT unaccent('Cybertec Schönig & Schönig GmbH');
            unaccent             
---------------------------------
 Cybertec Schonig & Schonig GmbH
(1 row)
content_copyCOPY

https://www.cybertec-postgresql.com/en/unaccent-getting-rid-of-umlauts-accents-and-special-characters/