Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

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 |
+---------+-----------------------+--------------------+--------+