The Position of Columns Seems To Be Incorrect When a Text File Holding a Mix of European and Arabic Characters Is Written by ODI

(Doc ID 2077130.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


An Oracle Data Integrator (ODI) Mapping / Interface that loads a mix of European and Arabic data into an UTF-8 comma delimited text file, seems to generate incorrect records:

Note that, when English characters only are used, there are 14 columns generated, and the columns get created in the expected order (with second and sixth columns ate their expected place).

When both English and Arabic data must be generated, customer expects the result to be as follows:



... but gets instead:

"1168","الينبوع","100218021","1 JEDH 24","1002180","جدة","2","JED","102","Brick and Mortar","33","Pharmacy KSA","1","Al Nahdi Medical Company"
"1169","الصالح","10021800","N/A","1002180","جدة","2","JED","102","Brick and Mortar","33","Pharmacy KSA","1","Al Nahdi Medical Company"

Observe above that:

In the ODI Studio > Topology, the File Data Server has been set to use:

JDBC Driver: com.sunopsis.jdbc.driver.file.FileDriver
JDBC Url: jdbc:snps:dbfile?ENCODING=UTF8


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