13.5.4.1.SHOWCHARACTERSET語法
13.5.4.1. SHOW
CHARACTER SET語法
SHOW CHARACTER SET [LIKE 'pattern']
SHOW CHARACTER SET語句用于顯示所有可用的字符集。該語句取一個自選的LIKE子句。該子句指示哪些字符集名稱可以匹配。舉例說明:
mysql> SHOW CHARACTER SET LIKE 'latin%';
+---------+-----------------------------+-------------------+--------+
| Charset | Description | Default collation | Maxlen |
+---------+-----------------------------+-------------------+--------+
| latin1 | cp1252 West European | latin1_swedish_ci | 1 |
| latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 |
| latin5 | ISO 8859-9 Turkish | latin5_turkish_ci | 1 |
| latin7 | ISO 8859-13 Baltic | latin7_general_ci | 1 |
+---------+-----------------------------+-------------------+--------+
Maxlen列顯示用于存儲一個字符的最大的字節數目。