CHR
All functions > STRING > CHR
Converts a Unicode code point to its corresponding character.
Syntax
CHR(expr)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
code_point | BIGINT | Yes | A BIGINT representing the Unicode code point |
Returns
The character corresponding to the code point
Notes
- Valid code points range from 0 to 1114111 (0x10FFFF)
- Returns NULL if the input is NULL
- Invalid code points may result in an error or undefined behavior
- This is the inverse operation of CODEPOINT