关于乱码的字符集
已经建的数据表乱码怎么解决，不知道怎么弄。
新建的数据表已经不存在乱码的问题，现在是我就想直接修改乱码的数据表，不想删了重建。
数据库、数据表、字段的字符集都改了，utf8，gbk都还是乱码
3 回答
MariaDB [test]> 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 | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
MariaDB [test]> 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 | latin1 || character_set_system | utf8 || character_sets_dir | /usr/share/mysql/charsets/ |+--------------------------+----------------------------+
把所有的都设置成UTF8
举报
0/150
提交
取消
