该表包含了可用的字符集
The CHARACTER_SETS
table provides information about available character sets.
INFORMATION_SCHEMA Name | SHOW Name | Remarks |
---|---|---|
CHARACTER_SET_NAME | Charset | |
DEFAULT_COLLATE_NAME | Default collation | |
DESCRIPTION | Description | MySQL extension |
MAXLEN | Maxlen | MySQL extension |
查看方式:
1. SELECT
*
FROM
INFORMATION_SCHEMA
.
CHARACTER_SETS
[
WHERE
CHARACTER_SET_NAME
LIKE
'wild'
]
2. SHOW
CHARACTER
SET
[
LIKE
'wild'
]