931 搜狐中電雲集

查看mysql的默認字符集

登錄MySql命令行客戶端：打開命令行

mysql –uroot –p 回車

輸入密碼

進入mysql後執行：show variables like “%char%”;

顯示結果應該類似如下：

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | utf8 |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

如果仍有編碼不是utf8的，請檢查配置文件，也可使用mysql命令設置：

set character_set_client = utf8;

set character_set_server = utf8;

set character_set_connection = utf8;

set character_set_database = utf8;

set character_set_results = utf8;

set collation_connection = utf8_general_ci;

set collation_database = utf8_general_ci;

set collation_server = utf8_general_ci;

以上命令有部分隻對當前登錄有效，所以不是很管用。

最後更新：2017-01-04 22:34:54