linux环境mysql的变量都设置了
character set client utf8
character set connection utf8
character set database utf8
character set filesystem utf8
character set results 编辑utf8
character set server utf8
character set system utf8
character sets dir /usr/local/mysql/share/mysql/charsets/
collation connection utf8_general_ci
collation database utf8_general_ci mysqldump -uroot -proot --default-character-set=utf8 数据库名 > 导出的文件名vi 查看还是乱码...
求解
character set client utf8
character set connection utf8
character set database utf8
character set filesystem utf8
character set results 编辑utf8
character set server utf8
character set system utf8
character sets dir /usr/local/mysql/share/mysql/charsets/
collation connection utf8_general_ci
collation database utf8_general_ci mysqldump -uroot -proot --default-character-set=utf8 数据库名 > 导出的文件名vi 查看还是乱码...
求解
set fileencodings=utf-8,gbk$:wq还有你确定,你确定你的数据库是UTF8吗。是不是创建的时候设置gb2312什么的了。
我用phpmyadmin备份是OK的
如果有条件,改用windows下的notepad++查看一下,看看是否是正常的?
有可能是vi显示的问题,需要更改相关设置。
我用mysqldump备份后的文件和phpmyadmin备份后的文件有对比的 首先容量大小就小了!用editplus看了 里边内容是乱码的!
MySQL 中文显示乱码