Skip to Content.
Sympa Menu

freetds - [freetds] UTF8 Sybase pb

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Arnaud L." <aranna AT free.fr>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] UTF8 Sybase pb
  • Date: Fri, 27 Jan 2006 22:26:26 +0100

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@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...





Archive powered by MHonArc 2.6.24.

Top of Page