freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] How to set charset with unixODBC and Freetds ???
- 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
-
[freetds] How to set charset with unixODBC and Freetds ???,
fabien, 11/06/2003
- Re: [freetds] How to set charset with unixODBC and Freetds ???, James K. Lowden, 11/07/2003
- <Possible follow-up(s)>
- [freetds] How to set charset with unixODBC and Freetds ???, fabien, 11/13/2003
Archive powered by MHonArc 2.6.24.