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 JUNE 16, 2022

Applies to:

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

Symptoms

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

  • From an Oracle table present in a database schema with the UTF8 character set (NLS_CHARACTERSET)
              
  • To a Microsoft SQLServer database table created with the SQL_Latin1_General_CP1_CI_AS collation (Microsoft term to designate the character set).

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

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.