CODEPOINT()

All functions > STRING > CODEPOINT()

Returns the Unicode code point of the first character in a string.

Signatures

Returns: The Unicode code point of the first character

CODEPOINT(string: VARCHAR) → BIGINT

Notes

• Only the first character of the input string is considered
• For multi-byte Unicode characters, returns the full Unicode code point of that character
• Returns NULL if the input is NULL (use NULL(VARCHAR); bare NULL is untyped and fails inference)
• Returns 0 for empty strings
• This is the inverse operation of CHR

Examples

SELECT
    -- ASCII value of 'A'
    f1 := CODEPOINT('A'),
    -- ASCII value of 'a'
    f2 := CODEPOINT('a'),
    -- ASCII value of '0'
    f3 := CODEPOINT('0'),
    -- Only first character is considered
    f4 := CODEPOINT('ABC'),
    -- Unicode code point for Euro symbol
    f5 := CODEPOINT('€'),
    -- Unicode code point for emoji
    f6 := CODEPOINT('😀'),
    -- NULL string yields NULL
    f7 := CODEPOINT(NULL(VARCHAR))
;