unaccent: Getting rid of umlauts, accents and special characters
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/
Comments