2,MySql数据库存入乱码,查询出来全改成uft-8,修改mysql配置文件my.ini内容为:default-character-set=utf8 查询下面
SHOW VARIABLES LIKE'character_set_%';
SET character_set_client='utf8';
SET character_set_connection='utf8';
SET character_set_database='utf8';
SET character_set_filesystem='utf8';
SET character_set_results='utf8';
SET character_set_server='utf8';
SET character_set_system='utf8';
SHOW VARIABLES LIKE '%collation%';
SET collation_connection='utf8_general_ci';
SET collation_database='utf8_general_ci;
SET collation_server='utf8_general_ci';
SHOW VARIABLES LIKE'character_set_%';
SET character_set_client='utf8';
SET character_set_connection='utf8';
SET character_set_database='utf8';
SET character_set_filesystem='utf8';
SET character_set_results='utf8';
SET character_set_server='utf8';
SET character_set_system='utf8';
SHOW VARIABLES LIKE '%collation%';
SET collation_connection='utf8_general_ci';
SET collation_database='utf8_general_ci;
SET collation_server='utf8_general_ci';