python解决mysql乱码问题

# encoding=utf-8
'''
Created on 2012-4-6

@author: yajunzhang
'''


import MySQLdb  
import sys
print sys.getdefaultencoding()
conn = MySQLdb.connect(host='*.*.*.*', user='zhang', passwd='8',db='db',charset='utf8')  
  
cursor = conn.cursor()  
count = cursor.execute('select name from category')  
  
print '总共有 %s 条记录',count  
  
#获取一条记录,每条记录做为一个元组返回  
print "只获取一条记录:"  
result = cursor.fetchone();  
print result[0]
#print 'ID: %s   info: %s' % (result[0],result[1])  
print 'info: %s' % result[0]
#获取3条记录，注意由于之前执行有了fetchone()，所以游标已经指到第二条记录了，也就是从第二条开始的所有记录  
print "只获取3条记录:"  
results = cursor.fetchmany(3)  
for r in results:  
    print r[0]  
  
print "获取所有结果:"  
#重置游标位置，0,为偏移量，mode＝absolute | relative,默认为relative,  
cursor.scroll(0,mode='absolute')  
#获取所有结果  
results = cursor.fetchall()  
for r in results:  
    print r[0]  
conn.close()