CHR

All functions > STRING > CHR

Returns the character corresponding to the given Unicode code point.

Signatures

Returns: The character corresponding to the code point

CHR(code_point: BIGINT) → VARCHAR

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

Examples

SELECT
    f1 := CHR(65),  -- ASCII character 'A'
    f2 := CHR(97),  -- ASCII character 'a'
    f3 := CHR(48),  -- ASCII character '0'
    f4 := CHR(8364),  -- Euro symbol
    f5 := CHR(128512)  -- Emoji character
;