[freetds] Cant's select columns with umlaute
Michael Schodra
mschodra at pecos.de
Tue Dec 9 07:07:51 EST 2008
Hello All,
I try to established a DB-Link from Oracle 11g to a MSSQL 2000 database but it doesn't work.
We install on Centos 5.1 (Linux 64bit).
Our database is Oracle 11.1.0.6.0 plus bugfix 7389110 and we installed the "linux.x64_11gR1_gateways".
I configured freetds and uinixodbc (see below)
I already told the unixodb folk about the problem, but they told me: ask the freetds folk. So I do now and I hope you can help me?
Here is my configuration and the problem.
1. unixODBC (unixODBC-2.2.11)
1.1 /etc/freetds.conf
combandb <http://forums.oracle.com/forums/>
host = 212.xxx.xxx.5
port = 1433
tds version = 8.0
Client Charset = UTF-8
1.2 /etc/odbcinst:
FreeTDS <http://forums.oracle.com/forums/>
Description = v0.64-1
Driver = /usr/lib64/libtdsodbc.so.0
Setup = /usr/lib64/libtdsodbc.so.0
FileUsage = 1
Trace = Yes
TraceFile = /tmp/sql.log
ODBC <http://forums.oracle.com/forums/>
Trace = Yes
TraceFile = /tmp/sql.log
ForceTrace = Yes
Pooling = No
1.3. /etc/odbc.ini
ODBC Data Sources <http://forums.oracle.com/forums/>
combandb = SQL-Connect
combandb <http://forums.oracle.com/forums/>
Driver = FreeTDS
Description = DB-Link (MSSQL)
Trace = Yes
Database = namedb
TraceFile = /tmp/sql.log
Servername = combandb
Port = 1433
/tmp/SQL.LOG
When I try to connect using isql I get the following message:
SQL> isql combandb UN PW
Connected! |
SQL> select ID, Ort, Straße from x_lt;
ISQLERROR: Could not SQLPrepare
Here is the SQL-Log
ODBC]18163http://SQLConnect.c3549
Entry:
Connection = 0xa82f970
Server Name = combandblength = 8 (SQL_NTS)
User Name = [******length = 5 (SQL_NTS)
Authentication = *********length = 9 (SQL_NTS)
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
ODBC18163http://SQLConnect.c4123
Exit:SQL_SUCCESS
ODBC18163http://SQLAllocHandle.c510
Entry:
Handle Type = 3
Input Handle = 0xa82f970
ODBC18163http://SQLAllocHandle.c872
Exit:SQL_SUCCESS
Output Handle = 0xa880670
ODBC18163http://SQLPrepare.c189
Entry:
Statement = 0xa880670
SQL = select ID, Ort, Straße from x_lt; length = 62 (SQL_NTS)
ODBC18163http://SQLPrepare.c364
Exit:SQL_ERROR
ODBC18163http://SQLFreeStmt.c140
Entry:
Statement = 0xa880670
Option = 1
Isql> select * from x_lt
Works well, but umlaute are missing.
Any idea is welcome!
Greetings
Michael
More information about the FreeTDS
mailing list