[求助]关于debian环境下通过M ySQLdb查询数据库时UnicodeDecodeError的 问题

最近在写些操作mysql数据的东西，发现写出来后windows下运行正常，但只要迁到debian环境下就无法查询带有中文的数据库了；

conn = MySQLdb.connect(host = host, db=db, user=user,
              passwd=passwd, use_unicode=1, charset='utf8')
cursor = conn.cursor()
query = "select * from tab where su = '待'"
cursor.execute(query)
row1=cursor.fetchall()

错误信息：
  File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 147, in execute
    query = query.encode(charset)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xb4 in position 35: ordinal not in range(128)


各位高手，这个是为什么啊？


也试过把 MySQLdb的cursor。execute改成
def execute(self, query, char="utf-8", args=None):
	charset = char
    query = query.encode(charset)

最终还是不行，数据库切切实实是utf8的啊。
	
= = = = = = = = = = = = = = = = = = = =
			

　　　　　　　　致
礼！
 



李李
2008-01-21


_______________________________________________
python-chinese
Post: send [email protected]
Subscribe: send subscribe to [email protected]
Unsubscribe: send unsubscribe to  [email protected]
Detail Info: http://python.cn/mailman/listinfo/python-chinese