The Position of Columns Seems To Be Incorrect When a Text File Holding a Mix of European and Arabic Characters Is Written by ODI
Last updated on MAY 19, 2017
Applies to:Oracle Data Integrator - Version 18.104.22.168.0 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:
- The columns appear in an unexpected order...
- Extra columns appear for some range of rows...
- Incorrect data is contained in some of the columns...
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:
"1169","الصالح","10021800","N/A","1002180","جدة","2","JED","102","Brick and Mortar","33","Pharmacy KSA","1","Al Nahdi Medical Company"
Observe above that:
- The first line has 15 columns... and incorrect data (the second column holding an "1"... and the fifth one holding "JEDH 24", not being expected... "1 JEDH 24" should have been generated instead)...
- Both the lines show the Arabic data in other positions then the expected 2 and 6...
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
Million Knowledge Articles and hundreds of Community platforms