SHOW CHARACTER SET;
上述代码将返回MySQL支持的所有字符集。此命令将返回一列包含“Charset”和“Description”两个字段的结果集。
Charset | Description ---------------------------------------- big5 | Big5 Traditional Chinese dec8 | DEC West European cp850 | DOS West European hp8 | HP West European koi8r | KOI8-R Relcom Russian latin1 | cp1252 West European latin2 | ISO 8859-2 Central European swe7 | 7bit Swedish ascii | US ASCII ujis | EUC-JP Japanese sjis | Shift-JIS Japanese hebrew | ISO 8859-8 Hebrew tis620 | TIS620 Thai euckr | EUC-KR Korean koi8u | KOI8-U Ukrainian gb2312 | GB2312 Simplified Chinese greek | ISO 8859-7 Greek cp1250 | Windows Central European gbk | GBK Simplified Chinese latin5 | ISO 8859-9 Turkish armscii8 | ARMSCII-8 Armenian utf8 | UTF-8 Unicode ucs2 | UCS-2 Unicode cp866 | DOS Russian keybcs2 | DOS Kamenicky Czech-Slovak macce | Mac Central European macroman | Mac West European cp852 | DOS Central European latin7 | ISO 8859-13 Baltic utf8mb4 | UTF-8 Unicode cp1251 | Windows Cyrillic utf16 | UTF-16 Unicode utf16le | UTF-16LE Unicode cp1256 | Windows Arabic cp1257 | Windows Baltic utf32 | UTF-32 Unicode binary | Binary pseudo charset geostd8 | GEOSTD8 Georgian cp932 | SJIS for Windows Japanese eucjpms | UJIS for Windows Japanese
您还可以使用以下命令查询MySQL默认字符集：
SHOW VARIABLES LIKE 'character_set%';
执行上述命令后，MySQL将返回其默认字符集的名称。
在查询MySQL支持的字符集时，使用上述命令非常方便。您可以使用这些命令深入了解MySQL的字符集设置。这将有助于更好地管理和优化您的MySQL服务器。