Character Set Conversions (Encoding) Cause Data Loss In ODI Integration Interfaces Loading Microsoft SQLServer Datastores (Doc ID 966637.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Nov-2013***

Symptoms

When attempting to load data into a Microsoft SQLServer 2005 Datastore using an Oracle Data Integrator (ODI) flow:

When checking the data in the target table, it appears that some characters have been lost and are represented as question marks (?).

For example, multi-byte data 원 용 선 present in the Oracle table is translated to ? ? ? after being loaded to Microsoft SQLServer.

Why does this happen?

Note that in the Microsoft SQLServer table, CHAR and VARCHAR data types have been used.

Cause

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 hundreds of Community platforms