mysql日文乱码问题怎么解决，急！急！急！

[ericfly]

取出来的纪录都是乱码,怎么解决？

[mathematician]

在my.ini文件中设置：
default-character-set= gbk
然后重启服务

[XqYuan]

在运行SQL语句之前，先设置字符集
SET character_set_client = gbk
SET character_set_connection = gbk
SET character_set_database = gbk
SET character_set_results = gbk
SET character_set_server = gbk

SET collation_connection = gbk_bin
SET collation_database = gbk_bin
SET collation_server = gbk_bin
然后再excute sql