mysql编码设置

 

1、修改编码：http://blog.sina.com.cn/s/blog_7122661501018v70.html

设置默认编码show variables like 'character_set_%';

set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set collation_connection = utf8_general_ci;
set collation_database = utf8_general_ci;
set collation_server = utf8_general_ci;

2、service mysql stop/restart/start

service mysqld stop/restart/start
repair  table `app`.`performance_assessment_point`;