简单修改数据库编码的方法~对乱码说再见(适合免费空间)

gbk

大大大大大大
没用啊，我全改成gbk了啊
数据库 friday_vxv_cn - 表 cdb_banklog 运行于 localhost
错误

SQL 查询 :  

ALTER TABLE `cdb_banklog` CHANGE `id` `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE `uid` `uid` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NOT NULL ,
CHANGE `username` `username` VARCHAR( 15 ) CHARACTER SET gbk NOT NULL ,
CHANGE `czid` `czid` TINYINT( 2 ) CHARACTER SET gbk DEFAULT '0' NOT NULL ,
CHANGE `moneynum` `moneynum` INT( 10 ) CHARACTER SET gbk DEFAULT '0' NOT NULL ,
CHANGE `begintime` `begintime` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ,
CHANGE `endtime` `endtime` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ,
CHANGE `islog` `islog` TINYINT( 1 ) CHARACTER SET gbk DEFAULT '0' NOT NULL ,
CHANGE `remark` `remark` TEXT CHARACTER SET gbk DEFAULT NULL ,
CHANGE `czip` `czip` VARCHAR( 15 ) CHARACTER SET gbk DEFAULT '0' NOT NULL

MySQL 返回:


#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET gbk DEFAULT '0' NOT NULL, CHANGE `moneynum` `moneynum` INT(10) CHA' at line 1

兄弟,我这样的问题怎么解决?
https://discuz.dismall.com/thread-286982-1-1.html

up

up

这个方法没有用的我用了把论坛搞乱了后来是把数据库都全部删除了再重新设置过

很好，支持

好，做个记号

收藏！

请问对表里已经有的数据会造成影响吗? 就是说以前旧编码记录的数据会转换成新编码吗?