我在数据库里新建了一个表,插入中文是乱码
表结构:
CREATE TABLE IF NOT EXISTS `supe_partyjoin` (
`hid` int(10) unsigned NOT NULL auto_increment,
`itemid` mediumint(8) unsigned NOT NULL,
`uid` mediumint(8) unsigned NOT NULL,
`username` char(15) NOT NULL,
`subject` char(50) NOT NULL,
PRIMARY KEY (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
浪漫æŒä¼šä¹‹ä¸ƒå¤•å‰å¥ 这种的
表结构:
CREATE TABLE IF NOT EXISTS `supe_partyjoin` (
`hid` int(10) unsigned NOT NULL auto_increment,
`itemid` mediumint(8) unsigned NOT NULL,
`uid` mediumint(8) unsigned NOT NULL,
`username` char(15) NOT NULL,
`subject` char(50) NOT NULL,
PRIMARY KEY (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
浪漫æŒä¼šä¹‹ä¸ƒå¤•å‰å¥ 这种的
set names utf8;
insert into supe_partyjoin values...