Important

The SingleStore 9.1 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 9.1.

SHOW CHARACTER SET

Syntax

SQL

SHOW {CHAR SET | CHARSET | CHARACTER SET}
   [WHERE Charset = '<charset_name>']

Output

The following table describes the columns returned by the SHOW CHARACTER SET command.

Column	Description
Charset	The name of the character set.
Description	Description of the character set.
Default collation	The default collation for this character set.
Maxlen	The maximum number of bytes required to store a single character in this character set.

Remarks

Refer to Character Sets Supported for information about supported character sets and their usage.
Available character sets can also be seen using the CHARACTER_SETS view.
Refer to Specifying Character Set and Collation for Clusters for information on specifying character sets.

Example

SQL

singlestore> SHOW CHARACTER SET;

+---------+-----------------------+--------------------+--------+
| Charset | Description           | Default collation  | Maxlen |
+---------+-----------------------+--------------------+--------+
| utf8mb4 | UTF-8 Unicode         | utf8mb4_bin        |      4 |
| utf8    | UTF-8 Unicode         | utf8_bin           |      3 |
| binary  | Binary pseudo charset | binary             |      1 |
+---------+-----------------------+--------------------+--------+