sqlserver - freeTDS

--安装
tar zxvf freetds-stable.tgz
 cd freetds-0.91
 ./configure --prefix=/usr/local/freetds --with-tdsver=8.0 --enable-msdblib --enable-dbmfix --enable-shared --enable-static
 make
 make install
 

--/root/.bashrc加入
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/freetds/lib/;

export FREETDS=/usr/local/freetds/bin
export PATH=${PATH}:$FREETDS

--/etc/ld.so.conf.d/freetds.conf加入
/usr/local/freetds/lib

--使之生效
# ldconfig

--/usr/local/freetds/etc/freetds.conf加入 
[LAB]
 host = 10.120.249.154
 port = 1433
 tds version = 8.0
 client chaeset = GBK
 

--crt中字符集设置成utf-8

--测试
root@rhel6ora11:[/root]#tsql -S LAB -U sa -P zuoqi33443344
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
1> use lab
2> go
1> select * from a
2> go
a
好        
goo      
(2 rows affected)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22193071/viewspace-1167551/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22193071/viewspace-1167551/