pymssql 中文乱码问题
操作系统:windows
开发环境:python 2.5 + pymssql 1.0.1
数据库:Sql Server 2005 中文
Python 使用一段时间了, 最头疼的还是中文编码问题。今天用 pymssql 写一些数据到 Sql Server 数据库里面时出现了问题。
# -*- coding: UTF-8 -*-
import pymssql
conn = pymssql.connect(host='192.168.10.167', user='sa', password='sa', database='Test')
cur = conn.cursor()
cmd = "INSERT INTO Demo VALUES('索引测试')";
cmd = cmd.decode('utf-8')
print cmd
cur.execute(cmd)
conn.commit()
conn.close()
import pymssql
conn = pymssql.connect(host='192.168.10.167', user='sa', password='sa', database='Test')
cur = conn.cursor()
cmd = "INSERT INTO Demo VALUES('索引测试')";
cmd = cmd.decode('utf-8')
print cmd
cur.execute(cmd)
conn.commit()
conn.close()
print 显示都是正确的, 但是 execute 报错
>>>
INSERT INTO Demo VALUES('索引测试')
Traceback (most recent call last):
File "E:\Workshop\python\overlay\test.py", line 15, in <module>
cur.execute(cmd)
File "C:\Python25\lib\site-packages\pymssql.py", line 185, in execute
self._source.execute_query(operation, params)
SystemError: \loewis\25\python\Objects\stringobject.c:4465: bad argument to internal function
但是去掉 cmd = cmd.decode('utf-8') 后写入数据又是乱码 "绱㈠紩娴嬭瘯"
调试了一下午,将
# -*- coding: utf-8 -*-
改为
# -*- coding: cp936 -*-
或
# -*- coding: gb2312 -*-
查询和更新都正常了,但是项目不是 utf-8 的了。
# -*- coding: cp936 -*-
import pymssql
conn = pymssql.connect(host='192.168.10.167', user='sa', password='sa', database='Test')
cur = conn.cursor()
cmd = "INSERT INTO Demo VALUES('索引测试')";
print cmd
cur.execute(cmd)
conn.commit()
conn.close()
import pymssql
conn = pymssql.connect(host='192.168.10.167', user='sa', password='sa', database='Test')
cur = conn.cursor()
cmd = "INSERT INTO Demo VALUES('索引测试')";
print cmd
cur.execute(cmd)
conn.commit()
conn.close()