ASCII() Function in MySQL

In this article, we are going to cover the ASCII function with examples and you will see the ASCII MYSQL query. And will also cover the ASCII code for the given character. Let’s discuss one by one.

ASCII function in MySQL is used to find the ASCII code of the leftmost character of a character expression.

Syntax :

ASCII(str)

Parameter :

This method accepts one parameter as mentioned above in the syntax and described below in the example.

• str – A string whose ASCII value of the leftmost character is to be retrieved.

Returns :

It returns the ASCII code of the leftmost character. It also returns 0 If the string is empty and NULL if the string is NULL.

Example-1 :

ASCII() function to check the value for a lowercase character.

SELECT ASCII('g')AS Lower_Case;

Output :

Lower_Case
103

Example-2 :

ASCII() function to check the value for a uppercase character.

SELECT ASCII('G')AS Upper_Case;

Output :

Upper_Case
71

Example-3 :

ASCII() function to check the value for a input string.

SELECT ASCII('MySQL')AS String_Value;

Output :

String_Value
77

Example-4 :

ASCII() function to check the value for every input string in a column under a table.

Table -Student_Details

Student_Id	Student_Name
101	Tina
102	Rohit
103	Aman
103	Sneha

SELECT ASCII(Student_Name)  AS Ascii_Name FROM Student_Details ;

Ascii_Name
84
82
65
83