My Oracle Support Banner

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

Last updated on SEPTEMBER 26, 2023

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Data Integration Platform Cloud Classic - Version 17.3.5 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 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!

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