ASCII Function in MSSQL and MySQL

ASCII Function returns the ASCII value of a passed character in both MySQL and MSSQL. If you passed more than one character it will return
the ASCII value of the leftmost character

MySQL Example

mysql> SELECT ASCII('a');

------------
97

mysql> SELECT ASCII('android');

----------
97

ASCII Function in MySQL

MS SQL Server Example

SELECT ASCII('a');

------------
97

SELECT ASCII('android');

----------
97

ASCII Function Example in MSSQL

Another Example of MSSQL ASCII function

Back to Converting Functions from MSSQL to MySQL

The MSSQL to MySQL Converter will automatically convert the MSSQL functions to it's equivalent in MySQL while converting veiws.