- MySQL Error
- Message: MySQL Query Error
- SQL: CREATE TABLE IF NOT EXISTS `uchome_com_gift` ( `id` int(10) unsigned NOT NULL auto_increment, `uid` mediumint(8) unsigned NOT NULL default '0', `fromuid` mediumint(8) unsigned NOT NULL default '0', `fromusername` char(15) character set UTF-8 NOT NULL default '', `giftid` int(10) NOT NULL, `show` tinyint(1) NOT NULL, `exchange` tinyint(1) NOT NULL, `love` tinyint(1) NOT NULL, `mode` tinyint(1) NOT NULL, `private` tinyint(1) NOT NULL, `annonymous` tinyint(1) NOT NULL, `note` char(80) character set UTF-8 NOT NULL, `senttime` int(10) NOT NULL, `recvtime` int(10) NOT NULL, `fromstat` tinyint(1) NOT NULL, `tostat` tinyint(1) NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1;
- Error: Unknown character set: 'UTF'
- Errno.: 1115
复制代码 什么问题 ?
呵呵...解决了...原因是 installsql.php 代码里面 :- $charset = $_SC['charset'];
复制代码 这段代码返回的值是: "UTF-8",而下面的代码判断是小写的:"utf-8",- if($charset=="utf-8"){
- $charset = "utf8";
- }
复制代码 所以判断不通过,,就会出现这样的问题....
[ 本帖最后由 shingye 于 2008-7-23 12:01 编辑 ] |