MySQL ASCII() Functions – String Functions

by · Published · Updated

MySQL ASCII() Functions: Syntax

ASCII ( string );

MySQL ASCII() Functions: Description

ASCII() function return the numeric value of left-most character.

ASCII() works for 8-bit characters.

MySQL ASCII() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|15%|15%|55%” colalign=”left|lef|lef|left”]
Name, Required /Optional, Value Type, Description
string , Required, String , If more than one character is entered. It will only return the value for the first character.
[/table]

MySQL ASCII() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Returns,
0,if string is the empty string.
NULL, if string is NULL.
[/table]

MySQL ASCII() Functions: Available from

[table caption=”” width=”100%” colwidth=”100%” colalign=”left”]
Version, MySQL 4.0
[/table]

 

MySQL ASCII() Functions: Example 1 :

mysql> SELECT ASCII(‘2’);
+————+
| ASCII(‘2’) |
+————+
| 50 |
+————+
1 row in set (0.00 sec)

mysql> SELECT ASCII(‘223’);
+————–+
| ASCII(‘223’) |
+————–+
| 50 |
+————–+
1 row in set (0.00 sec)

mysql> SELECT ASCII(‘a’);
+————+
| ASCII(‘a’) |
+————+
| 97 |
+————+
1 row in set (0.00 sec)

mysql> SELECT ASCII(‘ab’);
+————-+
| ASCII(‘ab’) |
+————-+
| 97 |
+————-+
1 row in set (0.00 sec)

Below is the mysql terminal screen for above code :

See all MySQL String functions MySQL 8 String Functions.

Related articles : ORD(), HEX(), CONCAT(), CONCAT_WS() , LOWER(), LTRIM(), INSTR(), POSITION().

PHP Related articles : SUBSTR(), SUBSTR_COUNT(), SUBSTR_COMPARE(), PHP5 STRING FUNCTIONS(), SUBSTR_REPLACE().

You may also like...