Impossible To Display Umlaut Characters Via DG4ODBC And With ODBC Driver For DB2 On AS400 Or ISeries (Doc ID 1500078.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Linux x86-64

Symptoms

Impossible to display umlaut characters via Database Gateway for ODBC (DG4ODBC)  and with ODBC driver for DB2 AS400 or  ISeries Access ODBC Connector For Linux X86_64 .

The DB2 character set is CCSID: 1141 GERMAN
Oracle character set in database: GERMAN_GERMANY.WE8MSWIN1252

HS_LANGUAGE parameter in the gateway init file is equal to GERMAN_GERMANY.WE8MSWIN1252

Result gives:
SQL> SELECT e002, w002, w005, w006 FROM mbs.V00019 where e002 = 1234;
+-------------+----------------------------+---------------------------------------------------+-------------------------------+
| E002 | W002 | W005 | W006 |
+-------------+----------------------------+---------------------------------------------------+-------------------------------+
| 1234 | Müller | Müller | GroÃe Muller |
+-------------+----------------------------+---------------------------------------------------+-------------------------------+

instead of

SQL> SELECT e002, w002, w005, w006 FROM mbs.V00019 where e002 = 1234;
+-------------+----------------------------+---------------------------------------------------+-------------------------------+
| E002 | W002 | W005 | W006 |
+-------------+----------------------------+---------------------------------------------------+-------------------------------+
| 1234 | Müller | Müller | Große Muller |
+-------------+----------------------------+---------------------------------------------------+-------------------------------+

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms