发现中文显示为“?”,然后我看了一下 mysql.ini,添加了两行
1 2 3 4 5
| [mysqld] port=3306 #下面的两行是添加的 character_set_client=utf8 character_set_server=utf8
|
后来再看 mysql 中的信息发现这样了,不过中文问题已经解决了。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| mysql> show variables like 'character%'; + + | 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 | E:\Soft\wamp\bin\mysql\mysql5.6.12\share\charsets\ | +
|