My Oracle Support Banner

ODI Incorrectly Handles UTF-8 Data Contained in Fixed-Format Flat Files (Doc ID 1923664.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
The article applies to all releases of ODI like the current 12C as well as to previous releases.

Symptoms

NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number or any other data represent a fictitious sample. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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:

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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