問題描述

mysql> show variables like "%colla%";+----------------------+-----------------+| Variable_name| Value |+----------------------+-----------------+| collation_connection | utf8_general_ci || collation_database | utf8_general_ci || collation_server | utf8_general_ci |+----------------------+-----------------+

mysql> show variables like "%char%";+--------------------------+-----------------------------------------------+| 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 | C:phpStudyPHPTutorialMySQLsharecharsets |+--------------------------+-----------------------------------------------+

mysql> create table emp3( -> `id` int(11) NOT NULL AUTO_INCREMENT, -> `username` varchar(50) NOT NULL, -> `balance` float NOT NULL, -> `province` varchar(20) NOT NULL, -> `age` tinyint(3) unsigned NOT NULL, -> `sex` tinyint(4) NOT NULL, -> PRIMARY KEY (`id`) -> ) ENGINE=InnoDB CHARSET=utf8;Query OK, 0 rows affected (0.03 sec)

問題解答

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