UTF8 Conversions when Using MGW/DBMS_AQ.DEQUEUE (é to é ) (Doc ID 2056218.1)

Last updated on SEPTEMBER 15, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

DBMS_AQ.DEQUEUE is being used to process messages which are taken by Oracle Message Gateway (MGW) from IBM's MQ series.  When handling some UTF8 characters conversions are incorrectly happening.   The source and target of the data are UTF8/AL16UTF16.  The issue is not observable from MQ side.  The source and target of the data is an Oracle database.

Site 1
~~~~~

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

NLS_CHARACTERSET                     UTF8
NLS_NCHAR_CHARACTERSET     AL16UTF16


Site 2
~~~~~~

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

NLS_CHARACTERSET                AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16



For example we get have this string (hex dumps):

sent       -- smé      -- c3a93c2
received  -- smé -- c383c2a93c2

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