drop table if exists 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 NAMES 'utf8'; insert into test (userid, title) values ('8', '‖耽'); insert into test (userid, title) values ('9', '‖['); check table test;