Mysl查看编码类型.docVIP

Mysql查看编码方式专题 一、查看数据库的字符集 showvariableslikecharacter\_set\_%; 输出： +--------------------------+--------+ |Variable_name|Value| +--------------------------+--------+ |character_set_client|latin1| |character_set_connection|latin1| |character_set_database|latin1| |character_set_filesystem|binary| |character_set_results|latin1| |character_set_server|latin1| |character_set_system|utf8| +--------------------------+--------+ 结合以下的编码表我们发现当前的数据库系统的编码： latin1_bin 西欧(多语言),二进制 binary 二进制 以上是我在linux环境中的查看的结果编码集了。我现在WIN平台上面查看编码集结果如： +--------------------------+--------+ |Variable_name|Value| +--------------------------+--------+ |character_set_client|utf8| |character_set_connection|utf8| |character_set_database|utf8| |character_set_filesystem|binary| |character_set_results|utf8| |character_set_server|utf8| |character_set_system|utf8| +--------------------------+--------+ 为什么会出现不一致的情况呢？在我本机上面是显示的UTF-8.而在LINUX上面居然是 二、通过命令修改其编码 创建数据库指定数据库的字符集 mysqlcreatedatabasemydbcharactersetutf-8;#直接指定其编码 直接通过命令进行修改 setcharacter_set_client=utf8; setcharacter_set_connection=utf8; setcharacter_set_database=utf8; setcharacter_set_results=utf8; setcharacter_set_server=utf8; 修改完了之后再查询 showvariableslikecharacter\_set\_%; +--------------------------+--------+ |Variable_name|Value| +--------------------------+--------+ |character_set_client|utf8| |character_set_connection|utf8| |character_set_database|utf8| |character_set_filesystem|binary| |character_set_results|utf8| |character_set_server|utf8| |character_set_system|utf8| +--------------------------+--------+ 结果全部都调整修改成UTF-8了！ 修改完了之后我看select*fromaddress_address;出现乱码了！Django也乱码 三、解决数据导入导出的乱码问题 #createdatabasenginxdjango; #usenginxdjango; #showvariableslikecharacter\_set\_%; #打印输出居然是如下 +--------------------------+--------+ |Variable_name|Value| +--------------------------+--------+ |character_set_client|latin1| |character_set_connection|latin1| |character_set_database|latin1| |character_set_filesystem|binary| |character_set_results|latin1| |character_