Mysql设置数据库编码

设置编码：

 

SET character_set_client = utf8;
SET character_set_connection = utf8;
SET character_set_database = utf8;
SET character_set_results = utf8;
SET character_set_server = utf8;

 

查看编码：

SHOW VARIABLES LIKE 'character%';