CHAR

Tips

This feature is supported since the Apache Doris 1.2 version

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