Special Characters Are not Loaded Properly to Target when Using the ODI File Driver
(Doc ID 2453398.1)
Last updated on AUGUST 10, 2023
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 to 18.104.22.168.181204 [Release 12c]
Oracle Data Integrator Cloud Service - Version 17.1.3 to 17.1.3
Information in this document applies to any platform.
In Oracle Data Integrator (ODI) Studio 22.214.171.124, a mapping has been configured which makes use of the "File" technology and associated driver.
After the mapping was executed, it was observed that special characters (such as °) were not loaded properly to the target. In the case of the degree sign (°), it was loaded as period instead (.).
Steps which can be used to reproduce
- Create a mapping in ODI Studio which makes used of a Fixed-format file with attribute datatypes set to "Fixed Ebcdic".
- Ensure that the source datastore for the mapping contains some data with special characters (such as °).
- Execute the mapping and observe that it will complete successfully.
- View the data for the target datastore and notice that lines containing special characters in the source datastore are inserted into the target, but the special characters are not loaded properly.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!