My Oracle Support Banner

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

Last updated on OCTOBER 02, 2023

Applies to:

Oracle Data Integrator - Version to [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.


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.


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.