Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

ASCII

Returns the ASCII value of the leftmost character of the given string.

Syntax

ASCII (str)

Arguments

  • str: any string or binary object
Info

ASCII only works with 8-bit characters.

Return Type

Integer, or NULL if str is NULL.

Examples

SELECT ASCII('abracadabra');
+----------------------+
| ASCII('abracadabra') |
+----------------------+
|                   97 |
+----------------------+