Wrong Character Conversion From an Unicode Informix Database Using DG4Informix (Doc ID 1133453.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for Informix - Version 11.2.0.1 and later
Information 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 -


Beļģija



 in the Informix table.
 When selected via the gateway we see -
 
 

name
 --------------------------------------------------
 BeĆ�Ā�Ć�Ā�ija


 The insert has been done correctly in Informix and the hex data corresponds to the  expected Unicode representation of the string -
 
 

62,65,c4bc,c4a3,69,6a,61


 
 A dump of column from the gateway shows -
 
 

select ", dump("name",16)
 42,65,c3,84,c2,bc,c3,84,c2,a3,69,6a,61


 
 which matches the Gateway trace level 255 output:

 

SQLFetch: row: 1, column 2, bflsz: 51, bflar: 50, (bfl: 50, mbl: 50)
 00: 4265C4BC C4A3696A 61202020 20202020 [Be....ija ]
 10: 20202020 20202020 20202020 20202020 [ ]


 

Changes

Fresh install of 11.2 DG4IFMX

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