sqlserver插入utf8文本数据

在文本字段前面添加N

import pymssql# server    数据库服务器名称或IP# user      用户名# password  密码# database  数据库名称conn = pymssql.connect('USER-PC', 'sa', '134619', 'ECM_test')cur = conn.cursor()  # 将数据库连接信息，赋值给cur。file=open("D:/沈伟/gaoxueya_test.txt",'r',encoding="utf8")for line in file:    result=line.strip().split(" ")    sql="insert into ccr_jufa_gaoxueya(ID,text) VALUES('%s',N'%s')"%(result[0],result[1])    print(sql)    cur.execute(sql)    conn.commit()sql="select text from ccr_jufa_gaoxueya"cur.execute(sql)result=cur.fetchall()for re in result:    print(re[0])conn.close()