SHOW CHARSET

Description

The "SHOW CHARSET" command is used to display the character sets available in the current database management system and some properties associated with each character set.

These properties may include the name of the character set, default collation, maximum byte length, etc. A list of character sets supported on the system and their details can be viewed by running the "SHOW CHARSET" command.

Syntax

SHOW CHARSET

Return Value

column name	description
Charset	Character Set
Description	Description
Default Collation	Default collation name
Maxlen	Maximum byte length

Examples

SHOW CHARSET;

+---------+---------------+-------------------+--------+
| Charset | Description   | Default collation | Maxlen |
+---------+---------------+-------------------+--------+
| utf8mb4 | UTF-8 Unicode | utf8mb4_0900_bin  | 4      |
+---------+---------------+-------------------+--------+