查看Mysql数据库字符编码可以在cmd命令后:
执行:show variables like '%char%';语句,
即可查看数据库中字符编码,如下图所示。
mysql> show variables like '%char%';
+--------------------------+----------------------------------------------------
-----+
| Variable_name | Value
|
+--------------------------+----------------------------------------------------
-----+
| character_set_client | gbk
|
| character_set_connection | gbk
|
| character_set_database | utf8
|
| character_set_filesystem | binary
|
| character_set_results | gbk
|
| character_set_server | utf8
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.6\share\chars
ets\ |
+--------------------------+----------------------------------------------------
-----+
8 rows in set (0.00 sec)
推 荐 阅 读
温暖冬季|
长按上图,关注跟我学VB公众平台
更多VB精彩内容,尽在VB学习