mysql 控制台环境下查询中文数据乱码，插入、更新中文数据不成功

 

 

 

 

登录mysql密码是加入编码参数--default-character-set，中文用gbk

mysql -uroot -pabctrans --default-character-set=gbk

 

想要utf-8的话你需要整个文件

mysql: Character set 'utf-8' is not a compiled character set and is not specified in the 'utf8/Index.xml' file