Position of Columns Appears Incorrect when Text File with Mix of European and Arabic Characters is Written by ODI
(Doc ID 2077130.1)
Last updated on JUNE 14, 2023
Applies to:Oracle Data Integrator - Version 126.96.36.199.0 and later
Oracle Data Integrator on Marketplace - Version 188.8.131.52.200123 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.
For example, when both English and Arabic data must be generated, the expected results are as follows:
... however, instead it is generated as:
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!