MySQL
服务器: 111.111.111.111 via TCP/IP
服务器版本: 5.1.44
协议版本: 10
用户: root@%
MySQL 字符集: cp1252 West European (latin1) 但是实际上数据库的字符集都设置为utf8了在phpadmin里执行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 utf8
character_set_system utf8
character_sets_dir /opt/app/mysql-5.1.44-linux-x86_64-glibc23/share/c... 不明白phpadmin右上角显示的字符集到底是什么字符集?为什么总是显示是 latin1?
服务器: 111.111.111.111 via TCP/IP
服务器版本: 5.1.44
协议版本: 10
用户: root@%
MySQL 字符集: cp1252 West European (latin1) 但是实际上数据库的字符集都设置为utf8了在phpadmin里执行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 utf8
character_set_system utf8
character_sets_dir /opt/app/mysql-5.1.44-linux-x86_64-glibc23/share/c... 不明白phpadmin右上角显示的字符集到底是什么字符集?为什么总是显示是 latin1?
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
他影响的只是你用phpmyadmin的时候,是否会正常显示中文字符