drop table test; CREATE TABLE `test` ( `ID` int(32) NOT NULL auto_increment, `UserID` int(32) NOT NULL default '0', `Title` varchar(255) NOT NULL default '', PRIMARY KEY (`ID`), KEY `UserID` (`UserID`), KEY `Title` (`Title`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; SET character_set_client = gbk; SET character_set_connection = utf8; insert into test (userid, title) values ('8', '¡¬µ¢'); insert into test (userid, title) values ('9', '¡¬['); check table test;