今天给大家介绍一下如何查询mysql的字符集。文章的内容小编觉得不错，现在给大家分享一下，觉得有需要的朋友可以了解一下，希望对大家有所帮助，下面跟着小编的思路一起来阅读吧。

方法：1、“show charset”语句，查看MYSQL所支持的字符集；2、“show create database 库名\G”语句，查看库的字符集；3、“show full columns from 表名”，查看表中所有列的字符集。

本教程操作环境：windows7系统、mysql8版本、Dell G3电脑。

查看字符集

1、查看MYSQL数据库服务器和数据库字符集

方法一：showvariableslike'%character%';方法二：showvariableslike'collation%';

方法一：

mysql>showvariableslike'%character%';+--------------------------+--------------------------------------+|Variable_name|Value|+--------------------------+--------------------------------------+|character_set_client|utf8||character_set_connection|utf8||character_set_database|utf8||character_set_filesystem|binary||character_set_results|utf8||character_set_server|utf8||character_set_system|utf8||character_sets_dir|/usr/local/mysql5535/share/charsets/|+--------------------------+--------------------------------------+8rowsinset(0.00sec)

方法二：

mysql>showvariableslike'collation%';+----------------------+-----------------+|Variable_name|Value|+----------------------+-----------------+|collation_connection|utf8_general_ci||collation_database|utf8_general_ci||collation_server|utf8_general_ci|+----------------------+-----------------+3rowsinset(0.00sec)

2、查看MYSQL所支持的字符集

使用show charset可查看MYSQL所支持的字符集

mysql>showcharset;+----------+-----------------------------+---------------------+--------+|Charset|Description|Defaultcollation|Maxlen|+----------+-----------------------------+---------------------+--------+|big5|Big5TraditionalChinese|big5_chinese_ci|2||dec8|DECWestEuropean|dec8_swedish_ci|1||cp850|DOSWestEuropean|cp850_general_ci|1||hp8|HPWestEuropean|hp8_english_ci|1||koi8r|KOI8-RRelcomRussian|koi8r_general_ci|1||latin1|cp1252WestEuropean|latin1_swedish_ci|1||latin2|ISO8859-2CentralEuropean|latin2_general_ci|1||swe7|7bitSwedish|swe7_swedish_ci|1||ascii|USASCII|ascii_general_ci|1||ujis|EUC-JPJapanese|ujis_japanese_ci|3||sjis|Shift-JISJapanese|sjis_japanese_ci|2||hebrew|ISO8859-8Hebrew|hebrew_general_ci|1||tis620|TIS620Thai|tis620_thai_ci|1||euckr|EUC-KRKorean|euckr_korean_ci|2||koi8u|KOI8-UUkrainian|koi8u_general_ci|1||gb2312|GB2312SimplifiedChinese|gb2312_chinese_ci|2||greek|ISO8859-7Greek|greek_general_ci|1||cp1250|WindowsCentralEuropean|cp1250_general_ci|1||gbk|GBKSimplifiedChinese|gbk_chinese_ci|2||latin5|ISO8859-9Turkish|latin5_turkish_ci|1||armscii8|ARMSCII-8Armenian|armscii8_general_ci|1||utf8|UTF-8Unicode|utf8_general_ci|3||ucs2|UCS-2Unicode|ucs2_general_ci|2||cp866|DOSRussian|cp866_general_ci|1||keybcs2|DOSKamenickyCzech-Slovak|keybcs2_general_ci|1||macce|MacCentralEuropean|macce_general_ci|1||macroman|MacWestEuropean|macroman_general_ci|1||cp852|DOSCentralEuropean|cp852_general_ci|1||latin7|ISO8859-13Baltic|latin7_general_ci|1||utf8mb4|UTF-8Unicode|utf8mb4_general_ci|4||cp1251|WindowsCyrillic|cp1251_general_ci|1||utf16|UTF-16Unicode|utf16_general_ci|4||cp1256|WindowsArabic|cp1256_general_ci|1||cp1257|WindowsBaltic|cp1257_general_ci|1||utf32|UTF-32Unicode|utf32_general_ci|4||binary|Binarypseudocharset|binary|1||geostd8|GEOSTD8Georgian|geostd8_general_ci|1||cp932|SJISforWindowsJapanese|cp932_japanese_ci|2||eucjpms|UJISforWindowsJapanese|eucjpms_japanese_ci|3|+----------+-----------------------------+---------------------+--------+39rowsinset(0.00sec)

3、查看库的字符集

语法：show create database 数据库\G;

mysql>showcreatedatabaseshiyan\G***************************1.row***************************Database:shiyanCreateDatabase:CREATEDATABASE`shiyan`/*!40100DEFAULTCHARACTERSETgbk*/1rowinset(0.00sec)

4、查看表的字符集

语法：show table status from 库名 like 表名;

mysql>showtablestatusfromclass_7like'test_info';+-----------+--------+---------+------------+------+----------------+-------------------------+-------------+------------+-----------------+----------+-|Name|Engine|Version|Row_format|Rows|Avg_row_length|Data_leate_time|Update_time|Check_time|Collation|Checksum|+-----------+--------+---------+------------+------+----------------+-------------------------+-------------+------------+-----------------+----------+-|test_info|InnoDB|10|Compact|10|1638|17-12-0519:01:55|NULL|NULL|utf8_general_ci|NULL|+-----------+--------+---------+------------+------+----------------+-------------------------+-------------+------------+-----------------+----------+-1rowinset(0.00sec)

5、查看表中所有列的字符集

语法：show full columns from 表名;

mysql>showfullcolumnsfromtest_info;+-------+----------+-----------------+------+-----+---------+-------+---------------------------------+---------+|Field|Type|Collation|Null|Key|Default|Extra|Privileges|Comment|+-------+----------+-----------------+------+-----+---------+-------+---------------------------------+---------+|id|int(3)|NULL|NO|PRI|NULL||select,insert,update,references|||name|char(12)|utf8_general_ci|YES||NULL||select,insert,update,references|||dorm|char(10)|utf8_general_ci|YES||NULL||select,insert,update,references|||addr|char(12)|utf8_general_ci|YES||未知||select,insert,update,references|||score|int(3)|NULL|YES||NULL||select,insert,update,references||+-------+----------+-----------------+------+-----+---------+-------+---------------------------------+---------+5rowsinset(0.00sec)

以上就是如何查询mysql的字符集的全部内容了，更多与如何查询mysql的字符集相关的内容可以搜索亿速云之前的文章或者浏览下面的文章进行学习哈！相信小编会给大家增添更多知识,希望大家能够支持一下亿速云！