set names gbk;结果还是出现乱码?
为什么我按老师的方法输入set names gbk;结果还是出现乱码?
| tdb_goods | CREATE TABLE `tdb_goods` (
`goods_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`goods_name` varchar(150) NOT NULL,
`goods_cate` varchar(40) CHARACTER SET latin1 NOT NULL,
`brand_name` varchar(40) CHARACTER SET latin1 NOT NULL,
`goods_price` decimal(15,3) unsigned NOT NULL DEFAULT '0.000',
`is_show` tinyint(1) NOT NULL DEFAULT '1',
`is_saleoff` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`goods_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=gbk |
需要修改默认的字符集为utf8吗