Purpose
This function returns a character based on a numeric parameter, and the returned value is related to the character set of the current system.
Syntax
CHR(n)
Parameters
The n parameter is used to retrieve the NUMBER code corresponding to the character. It is an integer value in the range [0, 4294967295].
Return type
The returned value is related to the character set of the current system. OceanBase Database supports the binary, utf8mb4, gbk, utf16, and gb18030 character sets.
Examples
Convert the decimal number 25700 to the corresponding character, with the character set being UTF-8.
obclient> SELECT CHR(25700) AS str FROM DUAL;
+------+
| STR |
+------+
| dd |
+------+
1 row in set