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.

Syntax:

CHAR (N…[USING characterset name])

Arguments:

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.

Code:

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

Previous: BIT_LENGTH
Next: CHARACTER_LENGT