String functions
ICU_NORMALIZE
Reference material for ICU_NORMALIZE function
Transliterate a string using a specified ICU transliterate ID.
Syntax
Parameters
Parameter | Description | Supported input types |
---|---|---|
<expression> | An input string to transliterate. | TEXT |
<transliterate_id> | A valid ICU library transliterate ID string. | TEXT |
Return Type
The ICU_NORMALIZE
function returns a result of type TEXT
.
Errors
If <transliterate_id>
is invalid, an error is thrown.
Examples
The following example normalizes the word ‘München’ using the Latin-ASCII transliterate ID:
normalized_word (TEXT) |
---|
Munchen |
The following example applies a similar operation to the UPPER function:
normalized_word (TEXT) |
---|
AABB |
The function only works for a valid ICU transliterate ID:
Fails with the following error: