MySQL Query Browser不能输入中文和英文字符,只能识别数字,怎么回事
我昨天刚按装了MySQL Query Browser5.0但是建表时不能输入中文和字符,我从网上搜了很多有关这方面的解决办法,比如改my.ini,(改了也没用)用dos方法查看时
mysql> SET character_set_client = utf8 ;
mysql> SET character_set_connection = utf8 ;
mysql> SET character_set_database = utf8 ;
mysql> SET character_set_results = utf8 ;
mysql> SET character_set_server = utf8 ;
以上设置都正常,但是
mysql> SET collation_connection = utf8 ;
mysql> SET collation_database = utf8 ;
mysql> SET collation_server = utf8 ;
会出现error 1273(hy000):unknown collation:'utf8'错误,我的mysql是5.0的,请问高手这是怎么事?