在运行sql语句之前,运行 SET character_set_client = ... SET character_set_connection = ... SET character_set_database = ... SET character_set_results = ... SET character_set_server = ...SET collation_connection = ... SET collation_database = ... SET collation_server = ... 设置字体,如果sql语句不含中文,实际上只需要 SET character_set_results =... 就可以了
在my.ini文件中设置: default-character-set= gbk 然后重启服务
我需要的是utf8的格式,SET character_set_client = ... SET character_set_connection = ... SET character_set_database = ... SET character_set_results = ... SET character_set_server = ...SET collation_connection = ... SET collation_database = ... SET collation_server = ... 这个我用过,设成utf8,存到数据库,读出来还是乱码
SET character_set_client = ...
SET character_set_connection = ...
SET character_set_database = ...
SET character_set_results = ...
SET character_set_server = ...SET collation_connection = ...
SET collation_database = ...
SET collation_server = ...
设置字体,如果sql语句不含中文,实际上只需要
SET character_set_results =...
就可以了
default-character-set= gbk
然后重启服务
SET character_set_connection = ...
SET character_set_database = ...
SET character_set_results = ...
SET character_set_server = ...SET collation_connection = ...
SET collation_database = ...
SET collation_server = ...
这个我用过,设成utf8,存到数据库,读出来还是乱码