好吧,有是扰人的乱码问题,在xshell下面查看,
mysql> show VARIABLES LIKE '%char%';
+--------------------------+----------------------------+
| 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/share/mysql/charsets/ |
+--------------------------+----------------------------+
navicat下看的中文显示正常,在数据存储的过程中,插入中文也正常,但是xshell查看具体的数据表时,中文显示的是乱码,虽然不影响使用,总觉得别扭。。。肯定事出有因,总想问个究竟,
这个算是强迫症么??
引用来自“Feng_Yu”的评论
你的xshell设置UTF8编码没?xshell默认是ASCII编码,需要改一下