UTF8 Conversions when Using MGW/DBMS_AQ.DEQUEUE (é to Ã© )
Last updated on SEPTEMBER 15, 2015
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
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.
Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production
Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
For example we get have this string (hex dumps):
sent -- smé -- c3a93c2
received -- smÃÂ© -- c383c2a93c2
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