SHOW CHARACTER SET

Precautions

N/A

Function

Displays all supported character sets.

Syntax

SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr]

Parameter Description

WHERE expr

Filter expressions.
LIKE 'pattern'

The pattern regular expression matches the name of the character set.

Return Result Set

Field	Description	Note
charset	character set name
Description	Description of the character set
default collation	Default sorting rules for character sets	The content of this field is empty
maxlen	The maximum number of bytes required to store a character.

Examples

MogDB=# SHOW CHARACTER SET LIKE 'a%';
 charset |    Description    | default collation | maxlen
---------+-------------------+-------------------+--------
 abc     | alias for WIN1258 |                   |      1
 alt     | alias for WIN866  |                   |      1
(2 rows)