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
• Returns NULL if the input is NULL
• Returns 0 for empty strings
• This is the inverse operation of CHR

Examples

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