將my.cnf中的MySQL默認字符集更改為UTF-8？目前，我們在PHP中使用以下命令將字符集設置為烏特夫-8在我們的申請中。由于這有點開銷，所以我們希望將其設置為MySQL中的默認設置。我們可以在/etc/my.cnf或其他地方這樣做嗎？SET NAMES 'utf8'SET CHARACTER SET utf8我已經在/etc/my.cnf中查找了默認字符集，但是沒有關于字符集的任何內容。此時，我執行了以下操作，將MySQL字符集和排序規則變量設置為UTF-8：skip-character-set-client-handshake
character_set_client=utf8
character_set_server=utf8這是處理這件事的正確方法嗎？
3 回答
飲歌長嘯
TA貢獻1951條經驗 獲得超3個贊
關于My.cnf的My.cnf中的MySQL 5.5
[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
結果是
mysql> show variables like "%character%";show variables like "%collation%";
+--------------------------+----------------------------+
| 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.00 sec)
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_unicode_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)
添加回答
舉報
0/150
提交
取消