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 and later
Information in this document applies to any platform.


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 -


 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 -

select ", dump("name",16)

 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 [ ]



Fresh install of 11.2 DG4IFMX


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