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.

Syntax Diagram:

MySQL CHAR() Function - Syntax Diagram

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

Previous: BIT_LENGTH

New Content: Composer: Dependency manager for PHP, R Programming