Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

CHAR

Processes each argument N as an integer and then returns a string consisting of the characters representing the code values of those integers.

Syntax

CHAR(N [ ,... ] [ USING character_set_name ])

Arguments

  • Integer

Return Type

  • Binary string

Remarks

CHAR() returns a binary string by default. To return a string in a different character set, use the optional USING flag.

Examples

SELECT CHAR(101);
+-----------+
| CHAR(101) |
+-----------+
| e         |
+-----------+

SELECT CHAR(77, 101, 109, 83, 81, 76);
+---------------------------+
| CHAR(77,101,109,83,81,76) |
+---------------------------+
| MemSQL                    |
+---------------------------+
1 row in set (0.06 sec)

SELECT CHARSET(CHAR(189));
+--------------------+
| CHARSET(CHAR(189)) |
+--------------------+
| binary             |
+--------------------+
1 row in set (0.06 sec)

SELECT CHARSET(CHAR(189 USING utf8));
+-------------------------------+
| CHARSET(CHAR(189 USING utf8)) |
+-------------------------------+
| utf8                          |
+-------------------------------+
1 row in set (0.06 sec)