Change MySql Database character set

来源:互联网 发布:创业软件上海分公司 编辑:程序博客网 时间:2024/05/16 09:42

Change MySql Database character set:
 mysql user/password: root/root
 
 Update my.ini
 
 default-character-set = utf8  -->> [client]
 character_set_server = utf8   -->> [mysqld]
 

 Check mysql character set:
 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/ |
 +--------------------------+----------------------------+