unaccent(...)Removes accents (diacritical marks) from a string.
Works with the following datatypes:
This function works with 2.1 and 3.0 endpoint(s). What does this mean? »
Use the unaccent(...) function to remove accents (diacritical marks) from a Text value. This is especially useful when working with geographic names (e.g., Montréal / Montreal) and other values that commonly appear in both accented and unaccented forms.
For example, you could use it to perform an “accent-insensitive” match on records in the City of Seattle’s library checkouts dataset:
The TryIt macro has been disabled until future notice while we upgrade this site to SODA3.