解决Python 2.6 连接 SQL Server 2000 乱码的问题

import pymssql
conn = pymssql.connect(host="192.168.0.2", user="sa", password="sa", database="MyDB")
cursor = conn.cursor()
cursor.execute("SELECT * FROM Table")
row = cursor.fetchone()
while row:
    print row[1].encode('latin1')
    row = cursor.fetchone()
conn.close()

注：SQL Server 2000是latin1编码。