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)