FreeTDS Development Group

[fabien <fabien AT secureops.com>]

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