为解决python连接sql server是出现的乱码，需要在连接sql server 时指定字符集utf8(client charset = UTF-8)，python环境制定了字符集变量(#coding=utf-8 )。
为解决python连接sql server是出现的乱码，需要在连接sql server 时指定字符集utf8(client charset = UTF-8)，python环境制定了字符集变量(#coding=utf-8 )。
vi /etc/freetds/freetds.conf
复制代码 代码如下:
[global]
# TDS protocol version
tds version = 8.0
client charset = UTF-8
# A typical Microsoft server
[Server55]
host = 192.168.1.55
port = 1433
tds version = 8.0
vi /etc/odbc.ini
[DSN55]
Description=my dsn
Driver=TDS
Database=qq99
Servername=Server55
tsql -S Server55 -U qq -P 123456 -D qq99
复制代码 代码如下:
#coding=utf-8
#!/usr/bin/python
import pyodbc
cnxn = pyodbc.connect("DSN=DSN55;UID=qq;PWD=123456")
cursor = cnxn.cursor()
cursor.execute('select * from orders where username=?','qq')
a=cursor.fetchall()
print 'pyodbc',a
关闭连接：
复制代码 代码如下:
csr.close()
del csr
conn.close()
