Syntax
ASCII(str)
Purpose
You can call this function to return the ASCII value of the leftmost character in the str string.
If str is an empty string, the function returns 0. If str is NULL, the function returns NULL.
Examples
obclient> SELECT ASCII('');
+-----------+
ASCII('')
+-----------+
0
+-----------+
1 row in set (0.00 sec)
obclient> SELECT ASCII('oceanbase');
+--------------------+
ASCII('oceanbase')
+--------------------+
111
+--------------------+
1 row in set (0.00 sec)
obclient> SELECT ASCII('Oceanbase');
+--------------------+
ASCII('Oceanbase')
+--------------------+
79
+--------------------+
1 row in set (0.00 sec)