Jump to: navigation, search

Mysql ASCII

From w3cyberlearnings

Contents

MySQL ASCII Function

This function returns the ASCII numeric value of the left most character of a string. ASCII() Returns Null when a given string is null and it works for 8-bit characters.

Syntax ASCII

  • Str: string or character input
ASCII(str);

Note

Related link ASCII_Standard or ASCII.

Example 1

mysql> SELECT ASCII('@');
+------------+
| ASCII('@') |
+------------+
|         64 |
+------------+
1 row in set (0.00 sec)

Example 2

mysql> SELECT ASCII('@eww');
+---------------+
| ASCII('@eww') |
+---------------+
|            64 |
+---------------+
1 row in set (0.00 sec)

Related Links


Navigation
Web
SQL
MISC
References