Suse10.3 下用 FreeDTS 连接数据库乱码问题
Suse10.3 下用Freetds连接sybase数据库总是出现乱码,无法显示中文。
1、sybase数据库字符集iso_1
2、 Version: freetds v0.82
3、Freetds.conf 为:
[sqlsybase]
host = 100.100.100.95
port = 5000
tds version = 5.0
client charset = cp936
4、locales.conf 为:
[default]
date format = %b %e %Y %I:%M:%S:%z%p
[en_US]
date format = %b %e %Y %I:%M:%S:%z%p
language = us_english
charset = cp936
[es_ES]
date format = %b %d %Y %I:%M%p
language = spanish
charset = iso_1
[pt_BR]
date format = %d/%m/%Y %H:%M
language = Portuguese
charset = iso_1
[it_IT]
date format = %d/%m/%Y %H:%M
language = Italiano
charset = iso_1
执行:TDSVER=5.0 tsql -S sqlsybase -Usa -Dqueuedb
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:
Default database being set to queuedb
Msg 2401, Level 11, State 2, Server Winstar, Line 0
Character set conversion is not available between client character set 'cp936' and server character set 'iso_1'.
Msg 2411, Level 10, State 1, Server Winstar, Line 0
No conversions will be done.
Msg 5704, Level 10, State 2, Server Winstar, Line 0
Changed client character set setting to '<NULL>'.
>
请高手指导一二,谢谢啦啦!