mysql的字符编码

首先要修改my.ini的 default-character-set和character-set-serve为自己想要的字符编码

character_set_server：这是设置服务器使用的字符集
     character_set_database：这是设置数据库使用的字符集
      character_set_client ：这是设置客户端发送Query串使用的字符集
      character_set_connection ：这是设置服务器需要将收到的查询串转换成的字符集
      character_set_results ：这是设置服务器要将结果数据转换到的字符集，转换后才发送给客户端
上面的是改整个数据库的，注意每张表还有自己的字符集。没弄对的话还是会报1366错误


通过MySQL命令行修改:

mysql> set character_set_client=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_server=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_system=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> set collation_connection=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> set collation_database=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> set collation_server=utf8;
Query OK, 0 rows affected (0.01 sec)


查看:
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
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       /usr/share/mysql/charsets/
+--------------------------+----------------------------+
8 rows in set (0.03 sec)

mysql> show variables like 'collation_%';
+----------------------+-----------------+
Variable_name        Value         
+----------------------+-----------------+
collation_connection utf8_general_ci
collation_database   utf8_general_ci
collation_server     utf8_general_ci
+----------------------+-----------------+
3 rows in set (0.04 sec)

-------------------------------------------------------------------------