Debian或Linux下mysql出现乱码问题的解决方案
在mysql的console上执行以下语句
SET character_set_connection=utf8, character_set_client=utf8, character_set_results=gb2312;
SET NAMES 'gb2312';
如果上边的不行,还可以改成Gbk。总以根据你的数据的文字编码改成相应的编码类型就ok了。给出Gbk的代码:
SET character_set_connection=utf8, character_set_client=gbK, character_set_results=gbK;
SET NAMES 'gbk';
如果还是不行,把就用
SET character_set_connection=gb2312, character_set_client=gb2312, character_set_results=gb2312;
SET NAMES 'gb2312';
重启mysql服务