出现了这样的错误:
Collation utf8_chinese_ci is not valid for character set utf8.
Valid collations are: utf8_general_ci utf8_bin utf8_czech_ci utf8_danish_ci utf8_esperanto_ci utf8_estonian_ci utf8_hungarian_ci utf8_icelandic_ci utf8_latvian_ci utf8_lithuanian_ci utf8_persian_ci utf8_polish_ci utf8_romanian_ci utf8_slovak_ci utf8_slovenian_ci utf8_spanish2_ci utf8_spanish_ci utf8_swedish_ci utf8_turkish_ci utf8_unicode_ci.
See the Installation chapter in the Reference Manual.
它的意思是对于character set utf8,utf8_chinese_ci 的定序是不可用的,可用的定序是:utf8_general_ci utf8_bin utf8_czech_ci utf8_danish_ci utf8_esperanto_ci utf8_estonian_ci utf8_hungarian_ci utf8_icelandic_ci utf8_latvian_ci utf8_lithuanian_ci utf8_persian_ci utf8_polish_ci utf8_romanian_ci utf8_slovak_ci utf8_slovenian_ci utf8_spanish2_ci utf8_spanish_ci utf8_swedish_ci utf8_turkish_ci utf8_unicode_ci中的任何一种,我把原来的配置utf8_chinese_ci 改为utf8_general_ci (其中的一种),就可以了!
出现这种错误的原因可能是mysql的版本不同引起的,不过这不是多么大的问题!呵呵