ICU_NORMALIZE

Transliterate a string using a specified ICU transliterate ID.

Syntax

ICU_NORMALIZE(<expression>, <transliterate_id>)

Parameter	Description	Supported input types
`<expression>`	An input string to transliterate.	`TEXT`
`<transliterate_id>`	A valid ICU library transliterate ID string.	`TEXT`

The ICU_NORMALIZE function returns a result of type TEXT.

If <transliterate_id> is invalid, an error is thrown.

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

⌘I