Blog

In this guide, we will explain how to use the MySQL ASCII function with syntax and examples.

Description

The MySQL ASCII function returns the numeric value of the left-most character of a string.

Syntax

The syntax for the ASCII function in MySQL is:

ASCII( single_character )

Parameters or Arguments

single_characterThe specified character to retrieve the NUMBER code for. If more than one character is entered, the ASCII function will return the value for the first character and ignore all of the characters after the first.

Applies To

The ASCII function can be used in the following versions of MySQL:

• MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23

Example

Let’s look at some MySQL ASCII function examples and explore how to use the ASCII function in MySQL.

For example:

mysql> SELECT ASCII('t');
Result: 116

mysql> SELECT ASCII('adglob.in');
Result: 116

mysql> SELECT ASCII('T');
Result: 84

mysql> SELECT ASCII('T2');
Result: 84

A listing of the ASCII values

ASCII (which stands for American Standard Code for Information Interchange) is a character encoding standard for text files in computers and other devices. ASCII is a subset of Unicode and is made up of 128 symbols in the character set. These symbols consist of letters (both uppercase and lowercase), numbers, punctuation marks, special characters and control characters. Each symbol in the character set can be represented by a Decimal value ranging from 0 to 127, as well as equivalent Hexadecimal and Octal values.

The following is a listing of ASCII values displaying the Decimal, Hexadecimal, Octal and Character values for each ASCII character.

Standard ASCII Characters

In the ASCII character set, the Decimal values 0 to 31 as well as Decimal value 127 represent symbols that are non-printable. It is possible to generate these non-printable characters using a key sequence where ^ represents the control key on your keyboard. For example, you could generate a carriage return (Decimal value 13) by pressing the control key followed by the letter M on your keyboard (^M).

All other symbols in the character set can printed or represented on the screen. These printable character values can be seen in the Char field in the table above.

Extended ASCII Characters

Next Topic : Click Here