Mysql查看编码类型.doc

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_set_server|latin1||character_set_system|utf8|+--------------------------+-