設定MySQL設定字元集和排序方式

1. 編輯/etc/my.cnf檔案, 在"[client]"下添加"default-character-set=utf8"
2. 編輯/etc/my.cnf檔案, 在"[mysqld]"下添加"default-character-set=utf8"
3. 重新啟動mysql服務
  # sudo /etc/init.d/mysqld restart
  * 查看系統字元集和排序方式

mysql> SHOW VARIABLES LIKE 'collation/_%';<br /> +--------------------------+--------+<br /> | Variable_name | Value |<br /> +--------------------------+--------+<br /> | character_set_client | utf8 |<br /> | character_set_connection | utf8 |<br /> | character_set_database | utf8 |<br /> | character_set_filesystem | binary |<br /> | character_set_results | utf8 |<br /> | character_set_server | utf8 |<br /> | character_set_system | utf8 |<br /> +--------------------------+--------+<br /> mysql> SHOW VARIABLES LIKE 'character/_set/_%';<br /> +----------------------+-----------------+<br /> | Variable_name | Value |<br /> +----------------------+-----------------+<br /> | collation_connection | utf8_general_ci |<br /> | collation_database | utf8_bin |<br /> | collation_server | utf8_general_ci |<br /> +----------------------+-----------------+

 

4. 設定資料庫字元集
  mysql> create database <database> default character set utf8 default collate utf8_bin;
  或者修改已有資料庫
  mysql> alter database <database> default character set utf8 default collate utf8_bin;

* 查看mysql支援的所有的COLLATION
  mysql> SHOW COLLATION;