My Oracle Support Banner

ODI File Topology Configured for Unicode Ignores Consecutive Field Separators (Doc ID 2756193.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

An Oracle Data Integrator (ODI) file topology is configured to import Unicode data containing multibyte characters. When the mapping is executed, ODI ignores consecutive field separators. Instead of inserting a null into the database column, subsequent data is inserted into the incorrect database column.

For example, a file contains the following row data:

The topology is configured for Encoding character set as UTF-8, and Multibyte_mode as 1. The model datastore is configured as a delimited file with the field separator set to comma.

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!


In this Document
Symptoms
Cause
Solution
References


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