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博客 ” ，链接：https://blog.itpub.net/22193071/viewspace-1167551/ ，如需转载，请注明出处，否则将追究法律责任。
