Transliterate a string using a specified ICU transliterate ID.

​
Syntax

ICU_NORMALIZE(<expression>, <transliterate_id>)

​
Parameters

ParameterDescriptionSupported 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: 
SELECT icu_normalize('München', 'Latin-ASCII') normalized_word
normalized_word (TEXT)
Munchen
The following example applies a similar operation to the UPPER function: 
select ICU_NORMALIZE('AabB','Any-Upper[^xyzXYZ]') normalized_word
normalized_word (TEXT)
AABB
The function only works for a valid ICU transliterate ID: 
select ICU_NORMALIZE('','X')
Fails with the following error: 
Line 1, Column 8: Unsupported locale: X
select ICU_NORMALIZE('','X')
       ^