unaccent(...)Removes accents (diacritical marks) from a string.
Works with the following datatypes:
This function works with 2.1 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:
https://data.seattle.gov/resource/tmmm-ytt6.json?$where=unaccent(lower(creator)) = 'john le carre'