Hi,

I always get error while I am trying the following sql:

ALTER TABLE data_business CHARACTER SET gb2312 COLLATE gb2312_chinese_ci

MySQL said:

#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 'COLLATE gb2312_chinese_ci' at line 1

Futhermore, I even can not run 'show character set;'

More, my development is the default of MySQl and it never asked to alter character set.

thanks;
Shawn