w3resource
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.

Syntax:

CHAR (N…[USING characterset name])

Arguments

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.

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

MySQL String Functions, slide presentation


ankara escort
kızılay escort