Documentation Index
Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
Use this file to discover all available pages before exploring further.
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 |
select ICU_NORMALIZE('AabB','Any-Upper[^xyzXYZ]') normalized_word
| normalized_word (TEXT) |
|---|
| AABB |
select ICU_NORMALIZE('','X')
Line 1, Column 8: Unsupported locale: X
select ICU_NORMALIZE('','X')
^
