Description

The ASCII( ) function works for 8-bit characters. It returns numeric value of the leftmost character of the string str. If str is empty, then it returns 0. If str is NULL, then it returns NULL.

The function has the form:

SELECT ASCII(str)

Parameter	Description
str	String

Return Value

0-if str is the empty string

NULL- If str is NULL

Leftmost character of the string.

Examples

The following example shows the basic use of this function:

mysql> SELECT ASCII('2');
-> 50
mysql> SELECT ASCII(2);
-> 50
mysql> SELECT ASCII('dx');
-> 100