Name
remove_unicode3_accents — strip combining diacritical marks from a Unicode string
Synopsis
varchar remove_unicode3_accents(
|
in str varchar); |
Description
remove_unicode3_accents returns a copy of
str with combining diacritical marks removed,
mapping each accented Unicode 3.x character to its base letter. The input
may be a narrow or wide string; the return type follows the input type.
Useful for accent-insensitive search keys and slug generation.
Parameters
str
A narrow or wide Unicode string.
Return Types
A varchar (or wide string) of the same kind as
str, with accents removed.
Examples
Example 24.205. Strip accents from a Latin string
SQL> select remove_unicode3_accents ('café');