ODI Incorrectly Handles UTF-8 Data Contained in Fixed-Format Flat Files
(Doc ID 1923664.1)
Last updated on JULY 21, 2020
Applies to:Oracle Data Integrator - Version 10.1.3.2.0 and later
Information in this document applies to any platform.
Having a fixed-format text file which contains UTF-8 data such as:
In Oracle Data Integrator (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
In ODI Studio > Designer, the fixed-format File Datastore has been defined as follows:
When consulting the data in the Datastore, or loading data with diacritics (á, ť, ň, İ, Ö, Ş ...) into the fixed-format file using ODI KMs or OdiSqlUnload, the data in the "Label" column is truncated:
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