发生的错误是Error Code: 1366
Incorrect string value: '\xA2' for column 'station_name' at row 1
(column‘station_name'即对应“杨柳红”)奇怪的是,我插入“杨柳”,或者“杨柳杨柳”等双数字数的中文时没有问题,但插入“杨”,“杨柳青”,“
杨柳杨柳青”等单数字数的中文时就会显示上述类似的错误我已经参考网上遇到该问题的方法,设置了"set names gbk",但依旧没有变化。insert into stationinfo values("杨柳红","YLQ","25","1");
Incorrect string value: '\xA2' for column 'station_name' at row 1
(column‘station_name'即对应“杨柳红”)奇怪的是,我插入“杨柳”,或者“杨柳杨柳”等双数字数的中文时没有问题,但插入“杨”,“杨柳青”,“
杨柳杨柳青”等单数字数的中文时就会显示上述类似的错误我已经参考网上遇到该问题的方法,设置了"set names gbk",但依旧没有变化。insert into stationinfo values("杨柳红","YLQ","25","1");
'character_set_connection', 'gbk'
'character_set_database', 'gbk'
'character_set_filesystem', 'binary'
'character_set_results', 'gbk'
'character_set_server', 'gbk'
'character_set_system', 'utf8'
'character_sets_dir', 'E:\Program Files\My SQL\share\charsets\'
show create table stationinfo;
CREATE TABLE `stationinfo` (
`station_name` varchar(30) NOT NULL,
`station_shortcode` char(5) NOT NULL,
`subbureau_code` varchar(3) NOT NULL,
`train_num` smallint(6) NOT NULL,
PRIMARY KEY (`station_name`,`subbureau_code`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk
SET NaMeS UTF8
再插入
不过是因为character_set_system是utf8,所以就应该要写set names utf8吗
MySQL 中文显示乱码