CHAR
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
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.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)
Related Topics
Last modified: September 20, 2024