CHAR
function char
description
Syntax
VARCHAR char(INT,..., [USING charset_name])
Interprets each argument as an integer and returns a string consisting of the characters given by the code values of those integers. NULL
values are skipped.
If the result string is illegal for the given character set, the result from CHAR()
becomes NULL
.
Arguments larger than 255
are converted into multiple result bytes. For example, char(15049882)
is equivalent to char(229, 164, 154)
.
Currently only utf8
is supported for charset_name
.
example
mysql> select char(68, 111, 114, 105, 115);
+--------------------------------------+
| char('utf8', 68, 111, 114, 105, 115) |
+--------------------------------------+
| Doris |
+--------------------------------------+
mysql> select char(15049882, 15179199, 14989469);
+--------------------------------------------+
| char('utf8', 15049882, 15179199, 14989469) |
+--------------------------------------------+
| 多睿丝 |
+--------------------------------------------+
mysql> select char(255);
+-------------------+
| char('utf8', 255) |
+-------------------+
| NULL |
+-------------------+
keywords
CHAR