My Oracle Support Banner

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

Last updated on JULY 16, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.