CHAR
Tips
This function is supported since the Apache Doris 1.2.
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