[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