如何修改MYSQL的字符编码

查看字符集设置 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.02 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.02 sec) mysql> 其他的一些设置方法： 修改数据库的字符集 mysql>use mydb mysql>alter database mydb character set utf-8; 创建数据库指定数据库的字符集 mysql>create database mydb character set utf-8; 通过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)