My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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:


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.