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_general_ci |      4 |
| utf8    | UTF-8 Unicode         | utf8_general_ci    |      3 |
| binary  | Binary pseudo charset | binary             |      1 |
+---------+-----------------------+--------------------+--------+

On this page

Syntax

Output

Remarks

Example

Was this article helpful?

On this page

Was this article helpful?