擅长:python、mysql、java
<p>这看起来确实是一个双重编码的情况;我对Python没有太多的经验,但是尝试按照<a href="http://tahpot.blogspot.com/2005/06/mysql-and-python-and-unicode.html" rel="nofollow noreferrer">http://tahpot.blogspot.com/2005/06/mysql-and-python-and-unicode.html</a>上的建议调整MySQL连接设置</p>
<p>我猜是因为连接是latin1,所以MySQL会在存储到UTF-8字段之前再次对字符串进行编码。这里的代码,特别是这一位:</p>
<blockquote>
<p>EDIT: With Python when establishing a
database connection add the following
flag: init_command='SET NAMES utf8'.</p>
<p>In addition set the following in
MySQL's my.cnf: default-character-set
= utf8</p>
</blockquote>
<p>可能是你想要的。在</p>