SingleStore Managed Service

ASCII

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

Syntax
ASCII (str)
Arguments
  • str: any string or binary object

Notice

ASCII only works with 8-bit characters.

Return Type

Integer, or NULL if str is NULL.

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