ASCII

​

Syntax

​

Scalar

ascii(value)

​

Arguments

​

Returns

• Type: INT
• Possible values: The first Unicode scalar value as an integer; zero for an empty string.
• NULL behavior: Returns NULL for NULL input.

​

Properties

​

Usage notes

• Non-ASCII Unicode characters are supported despite the function’s name.

​

Examples

​

Typical behavior

SELECT ascii('abc') AS ascii_character, ascii('🚀') AS unicode_character, ascii('') AS empty_value;

​

Leading character only

SELECT ascii('Zoo') AS uppercase_z, ascii('zoo') AS lowercase_z;