mysql配置沒問題，但不顯示中文；

Question

mysql>顯示變數如“%cola%”;
---------------------------------- ---- ------------ -
|變項名稱        |值           |
---------------------------------- ----------- ------
|排序規則連線 | utf8_general_ci |
| collat​​ion_database | | utf8_general_ci |
| collat​​ion_server     | utf8_general_ci |
---------------------- -----------------

mysql>顯示變數如“%char%”;
-------------------------- ------------ -----------------------------------
|變項名稱            |值                                    ----------------
|字符集客戶     | utf8                                字符集連接 | utf8                                字符集資料庫utf8                                字符集檔案系統 |二元                                   字符集結果    | utf8                                字符集伺服器     | utf8                                字符集系統     | utf8                                字符集_目錄       | C:\phpStudy\PHPTutorial\MySQL\share\charsets\ |
-------------------------- ------- -------------------------------------------------- --

mysql>建立表格 emp3(
    ->   `id` int(11) NOT NULL AUTO_INCRMENT,
    ->   `username` varchar(50) NOT NULL,
  ->   `province` varchar(20) NOT NULL,
    ->   `age` tinyint(3) unsigned NOT NULL,
    ->  (`id`)
    -> ) ENGINE=InnoDB CHARSET=utf8;
查詢正常，0 行受影響（0.03 秒）

#

Answer 1

因為cmd命令列的字元編碼是gbk,所以你插入的是gbk編碼的數據，而你的表是utf8編碼，所以插入會亂碼，你可以試建一個gbk編碼的數據表，執行set names gbk;然後再命令列插入資料