My Oracle Support Banner

Special Characters are not Loaded Properly to Target when using the ODI File Driver (Doc ID 2453398.1)

Last updated on OCTOBER 04, 2022

Applies to:

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


In Oracle Data Integrator (ODI) Studio, 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

  1. Create a mapping in ODI Studio which makes used of a Fixed-format file with attribute datatypes set to "Fixed Ebcdic".
  2. Ensure that the source datastore for the mapping contains some data with special characters (such as °).
  3. Execute the mapping and observe that it will complete successfully.
  4. 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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.