Skip to Content.
Sympa Menu

freetds - [freetds] How to set charset with unixODBC and Freetds ???

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: fabien <fabien AT secureops.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] How to set charset with unixODBC and Freetds ???
  • Date: Thu, 13 Nov 2003 14:45:58 -0500

Then, I'm using :
- FreeTDS 0.61
- unixODBC 2.2.5 and 2.2.6
- Linux RedHat 7.3 with 2.4.18-27.7 kernel

I made, some more tests, as you ask, with tsql.. After correcting some
settings, tsql is working fine...

freetds.conf :
--------------
[TEST]
host = computer.dev.com
port = 1433
tds version = 8.0
client charset = ISO_8859-1

and log is good with export TDSDUMP=/tmp/freetds.log

freetds.log :
-------------
2003-11-13 14:28:06.882155 iconv will convert client-side data to the
"ISO_8859-1" character set
2003-11-13 14:28:06.882636 Connecting addr 192.168.240.146 port 1433 with TDS
version 8.0

But, I still have the same problem with isql, which is the sql interface of
unixODBC...

SQL> insert into test values (1,1,'é')
[unixODBC] Msg 105, Level 15, State 1, Server DUALX, Line 1
Unclosed quotation mark before the character string '.?'.

[unixODBC] Msg 170, Level 15, State 1, Server DUALX, Line 1
Line 1: Incorrect syntax near '.?'.

[ISQL]ERROR: Could not SQLExecute
SQL>

If I'm looking my log file, I can verified that character set is not set as
isql was.

freetds.log :
-------------
2003-11-13 14:30:03.075233 iconv will convert client-side data to the ""
character set
2003-11-13 14:30:03.075639 Connecting addr 192.168.240.146 port 1433 with TDS
version 8.0

Then, what should I do to make working with unixODBC too ???
I think I need to set the character set too... Yes, but how or where ???
I also check unixODBC documentation, but I find nothing for the moment...

Fabien TEYSSEIRE




Archive powered by MHonArc 2.6.24.

Top of Page