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, 6 Nov 2003 17:47:58 -0500

Hi everyone,

I have a trouble... I'm using FreeTDS and UnixODBC with the following
configuration files :

odbcinst.ini :
--------------
[FREETDS]
DRIVER = /usr/lib/libtdsodbc.so
THREADING = 0

ODBC.ini :
----------
[TDS]
DRIVER = FREETDS
SERVER = computer.dev.com
PORT = 1433
TDS_VERSION = 8.0
DATABASE = database

and using dump file with export TDSDUMP=/tmp/freetds.log

I'm using TDS version 8.0 because I'm using a log of bigint into my
database...

Now, the problem, I cannot inserted accentuated characters, but I can with
TDS version 4.2 and I need TDS version 8.0 for bigint...

Sample :

SQL> create table test (id bigint, nb bigint, str varchar (255))

SQL> insert into test (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



In looking my dump file, I saw that the character set is not set... OK, but
where can I set it ? I tryed in the freetds.conf file, but this file seems to
be not read with unixODBC... No ???

Starting log file with debug level 99.
2003-11-06 17:30:33.744138 iconv will convert client-side data to the ""
character set
2003-11-06 17:30:33.744479 Connecting addr 192.168.240.146 port 1433 with TDS
version 8.0
2003-11-06 17:30:33.744914 inside tds_process_login_tokens()
Received header @ 2003-11-06 17:30:33.745791


Fabien TEYSSEIRE





Archive powered by MHonArc 2.6.24.

Top of Page