[freetds] UTF8 Sybase pb
Arnaud L.
aranna at free.fr
Fri Jan 27 16:26:26 EST 2006
Hi all,
I have a table on a Sybase 12.5 server.
Here my FreeTDS configuration for this server :
[MYASE]
host = machine
port = 6000
tds version = 5.0
client charset = UTF-8
When trying to connect, i have :
[root at migoo freetds-0.63]# tsql -U mylogin -S MYASE
locale is "en_US"
locale charset is "ISO-8859-1"
Password:
Msg 5704, Level 10, State 1, Server TNGI, Line 0
Changed client character set setting to 'iso_1'.
When i make a select on utf8 table, the output is iso1 (like indicate on
login)..
What wrong ? i have indicate that "client charset = UTF-8" for this
server... why it switch on iso-1 ?
To check why i have make a dump like this
22:21:24.478726 Got a match.
22:21:24.478740 option = 'host' value = 'machine'.
22:21:24.478755 Found host entry kerry.
22:21:24.516939 IP addr is xxx.xxx.xxx.xxx
22:21:24.516983 option = 'port' value = '6000'.
22:21:24.517001 option = 'tds version' value = '5.0'.
22:21:24.517046 option = 'client charset' value = 'UTF-8'.
22:21:24.517062 tds_config_login:453: client charset is UTF-8.
but the last line of dump file is :
22:21:24.517598 tds_config_login:483: client_charset is ISO-8859-1.
..... Any help would be appreciate.
Thanks a lot...
More information about the FreeTDS
mailing list