下面是错误提示:大家看看是什么问题 帮忙解决一下谢谢了
SQL 查询: --
-- 数据库: `sq_ppss`
--
-- ------------------------------------------------------
--
--
-- 表的结构 `dede__baoming`
--
CREATE TABLE IF NOT EXISTS `dede__baoming` (`id` int( 50 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 20 ) NOT NULL ,
`sex` varchar( 20 ) NOT NULL ,
`maileaddr` varchar( 80 ) NOT NULL ,
`hometel` varchar( 15 ) NOT NULL ,
`qq` varchar( 15 ) NOT NULL ,
`email` varchar( 50 ) NOT NULL ,
`time` int( 15 ) NOT NULL ,
`luqu` int( 1 ) NOT NULL default '0',
`zhuanye` varchar( 50 ) NOT NULL ,
`beizhu` text NOT NULL ,
`ip` varchar( 40 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = gbk AUTO_INCREMENT
=1;MySQL 返回: #1115 - Unknown character set: 'gbk'
SQL 查询: --
-- 数据库: `sq_ppss`
--
-- ------------------------------------------------------
--
--
-- 表的结构 `dede__baoming`
--
CREATE TABLE IF NOT EXISTS `dede__baoming` (`id` int( 50 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 20 ) NOT NULL ,
`sex` varchar( 20 ) NOT NULL ,
`maileaddr` varchar( 80 ) NOT NULL ,
`hometel` varchar( 15 ) NOT NULL ,
`qq` varchar( 15 ) NOT NULL ,
`email` varchar( 50 ) NOT NULL ,
`time` int( 15 ) NOT NULL ,
`luqu` int( 1 ) NOT NULL default '0',
`zhuanye` varchar( 50 ) NOT NULL ,
`beizhu` text NOT NULL ,
`ip` varchar( 40 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = gbk AUTO_INCREMENT
=1;MySQL 返回: #1115 - Unknown character set: 'gbk'
另外你的MYSQL版本是多少?
SHOW CHARACTER SET Charset Description Default collation Maxlen
dec8 DEC West European dec8_swedish_ci 1
cp850 DOS West European cp850_general_ci 1
hp8 HP West European hp8_english_ci 1
koi8r KOI8-R Relcom Russian koi8r_general_ci 1
latin1 cp1252 West European latin1_swedish_ci 1
latin2 ISO 8859-2 Central European latin2_general_ci 1
swe7 7bit Swedish swe7_swedish_ci 1
ascii US ASCII ascii_general_ci 1
hebrew ISO 8859-8 Hebrew hebrew_general_ci 1
koi8u KOI8-U Ukrainian koi8u_general_ci 1
greek ISO 8859-7 Greek greek_general_ci 1
cp1250 Windows Central European cp1250_general_ci 1
latin5 ISO 8859-9 Turkish latin5_turkish_ci 1
armscii8 ARMSCII-8 Armenian armscii8_general_ci 1
utf8 UTF-8 Unicode utf8_general_ci 3
cp866 DOS Russian cp866_general_ci 1
keybcs2 DOS Kamenicky Czech-Slovak keybcs2_general_ci 1
macce Mac Central European macce_general_ci 1
macroman Mac West European macroman_general_ci 1
cp852 DOS Central European cp852_general_ci 1
latin7 ISO 8859-13 Baltic latin7_general_ci 1
cp1251 Windows Cyrillic cp1251_general_ci 1
cp1256 Windows Arabic cp1256_general_ci 1
cp1257 Windows Baltic cp1257_general_ci 1
binary Binary pseudo charset binary 1
geostd8 GEOSTD8 Georgian geostd8_general_ci 1
DEFAULT CHARSET = utf8
GBK怎么转换UTF8 请指点一下