You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

CHAR

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. To return a string in a different character set, use the optional USING flag.

Examples

memsql> select char(101);
+-----------+
| char(101) |
+-----------+
| e         |
+-----------+

memsql> select char(77, 101, 109, 83, 81, 76);
+---------------------------+
| char(77,101,109,83,81,76) |
+---------------------------+
| MemSQL                    |
+---------------------------+
1 row in set (0.06 sec)

memsql> select charset(char(189));
+--------------------+
| charset(char(189)) |
+--------------------+
| binary             |
+--------------------+
1 row in set (0.06 sec)

memsql> select charset(char(189 using utf8));
+-------------------------------+
| charset(char(189 using utf8)) |
+-------------------------------+
| utf8                          |
+-------------------------------+
1 row in set (0.06 sec)


Related Topics