Language problem: ODBC changes special characters
675860Dec 16 2008 — edited Dec 17 2008We are running Oracle 10g and have some clients that need access to some views using an ODBC-connection.
Installation of the Instant Client and ODBC package went without trouble. We established a system DSN and the client has a successful connection to the database.
Some special characters (for example german "ä","ö","ü" and the symbol "Ø" for diameter) are howewer changed when viewed in Access or other 3rd party programms that use that system DSN ("ä" becomes "a", "ö" becomes "o", "Ø" becomes "?", etc.).
I guess there may be just a single setting we missed to configure. Can anybody help?
TNSNAMES.ORA (hostname changed):
ORACLE_DEVELOP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xyz)
)
)
Edited by: user10620045 on 16.12.2008 02:12