Pyhton 操作数据库返回中文

设置charset

def GET(self):
    conn = MySQLdb.connect(host='localhost', user='root', passwd='', db='test', port=3306, charset='utf8', cursorclass=MySQLdb.cursors.DictCursor)
    cur = conn.cursor()
    cur.execute("select * from articles")
    r = cur.fetchall()
    cur.close()
    conn.close()
    print r
    return render.articles(r)