|
马上注册,结交更多好友,享用更多功能^_^
您需要 登录 才可以下载或查看,没有账号?立即注册
x
import pymssql as pys
host='XX.X.XX.XXX'
uid='XX_XXX'
psd='123456'
db='数据系统'
conn=pys.connect(host=host,user=uid,password=psd,database=db,charset='cp936')
cur=conn.cursor()
msql='select * from sysobjects'
cur.execute(msql)
rel=cur.fetchall()
当db为英文数据库名称时,没有问题;当db为中文数据库名称时,总是报错,python版本是3.6.1;如下所示:
Traceback (most recent call last):
File "C:\Users\liping_xie\Desktop\STM - 副本.py", line 12, in <module>
conn=pys.connect(host=host,user=uid,password=psd,database=db,charset='utf8')
File "src\pymssql.pyx", line 636, in pymssql.connect
File "src\_mssql.pyx", line 1957, in _mssql.connect
File "src\_mssql.pyx", line 653, in _mssql.MSSQLConnection.__init__
UnicodeEncodeError: 'ascii' codec can't encode characters in position 0-5: ordinal not in range(128)
请教论坛各路大神,请问该如何设置才能不报错呢?非常感谢!!
|
|