Wrong Character Conversion From an Unicode Informix Database Using DG4Informix
(Doc ID 1133453.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database Gateway for Informix - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
Character set conversion issues over a DG4IFMX gateway point to an Informix table with Unicode data.
The incorrect and wrong results are due to a problem with char conversion of an UTF-8 char column
stored in Informix table selected using DG4IFMX 11.2.
For example, there is the string -
in the Informix table.
When selected via the gateway we see -
--------------------------------------------------
BeĆ�Ā�Ć�Ā�ija
The insert has been done correctly in Informix and the hex data corresponds to the expected Unicode representation of the string -
A dump of column from the gateway shows -
42,65,c3,84,c2,bc,c3,84,c2,a3,69,6a,61
which matches the Gateway trace level 255 output:
00: 4265C4BC C4A3696A 61202020 20202020 [Be....ija ]
10: 20202020 20202020 20202020 20202020 [ ]
Changes
Fresh install of 11.2 DG4IFMX
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 |
Changes |
Cause |
Solution |
References |