1安装
最后配置文件处问题,前面有个
叉号,不能写成功。是因为安装路径不能有中文!!!!
2安装时的编码设置为utf8
3不能插入中文的问题,一插就报错!!!
表和表中属性的的字符集也要改成utf8
4不能显示中文(naivecat管理工具)
设置编码为utf8
mysql> set names utf8;
Query OK, 0 rows affected
mysql> Show variables like '%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 | E:\MySoftware\share\charsets\ | +--------------------------+-------------------------------+ 8 rows in set mysql>