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)