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