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 (in FeatureQL use NULL(BIGINT); bare NULL is untyped and fails inference)
• Invalid code points are rejected with an error
• 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
    f6 := CHR(NULL(BIGINT)) -- NULL code point yields NULL
;