在項(xiàng)目中發(fā)現(xiàn)這樣一個(gè)問(wèn)題：sqlserver數(shù)據(jù)庫(kù)編碼為gbk，使用python3.4+pymssql 查詢，中文亂碼，經(jīng)過(guò)一番思考問(wèn)題解決，下面把解決辦法分享給大家：

conn = pymssql.connect(host="192.168.122.141",

port=1433,

user="myshop",

password="oyf20140208HH",

database="mySHOPCMStock",

charset='utf8',

as_dict=True) cur = conn.cursor()sql = "select top 10 [ID],[Name] from [User]"cur.execute(sql)list = cur.fetchall()for row in list: print(row["ID"],row["Name"].encode('latin-1').decode('gbk'))