python连接sql server乱码的解决方法

为解决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

　　

mac 电脑使用homebrew安装的freetds路径是在:/usr/local/opt/freetds/etc/freetds.conf