ICU_NORMALIZE

Reference material for ICU_NORMALIZE function

Transliterate a string using a specified ICU transliterate ID.

Syntax

ICU_NORMALIZE(<expression>, <transliterate_id>)

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:

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')
       ^