w3resource logo
MYSQL Tutorial

MySQL CHAR() function

CHAR() function

MySQL CHAR() returns the character value of the given integer value according to the ASCII table. It ignores the NULL value.


CHAR (N…[USING characterset name])


Name Description
N Integers whose character values (according to the ASCII table) are to be retrieved.

MySQL Version: 5.6

Video Presentation

Example: MySQL CHAR() function

The following MySQL statement returns character values (according to the ASCII table) of the integers 67, 72, 65 and 82.


SELECT CHAR(67,72,65,82); 

Sample Output:

mysql> SELECT CHAR(67,72,65,82);
| CHAR(67,72,65,82) |
| CHAR              | 
1 row in set (0.02 sec)

All String Functions

MySQL String Functions, slide presentation

ankara escort ankara escort ankara escort antalya escort alanya escort