SHOW CHARACTER SET

The SHOW CHARACTER SET command shows supported character sets and the default collation for each character set.

Syntax

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

Example

singlestore> SHOW CHARACTER SET;
+---------+-----------------------+--------------------+--------+
| Charset | Description           | Default collation  | Maxlen |
+---------+-----------------------+--------------------+--------+
| utf8mb4 | UTF-8 Unicode         | utf8mb4_general_ci |      4 |
| utf8    | UTF-8 Unicode         | utf8_general_ci    |      3 |
| binary  | Binary pseudo charset | binary             |      1 |
+---------+-----------------------+--------------------+--------+

Last modified:

Was this article helpful?