My Oracle Support Banner

CL8MSWIN1251 To AL32UTF8 With Source And Target Having Different NLS_LENGTH_SEMANTICS (Doc ID 2560210.1)

Last updated on JULY 01, 2019

Applies to:

Oracle GoldenGate - Version 18.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Problem with replication from source with different encoding and different NLS_LENGTH_SEMANTICS.


When we replicate from source with encoding CL8MSWIN1251 to target with AL32UTF8 . We lose part of string

For example- create table in source

create table TEST_TABLE
(
  ID NUMBER not null
  primary key,
  TEST VARCHAR2(6 char),
  TEST2 VARCHAR2(6)
)
INSERT INTO "<SCHEMA>"."TEST_TABLE" ("ID", "TEST", "TEST2") VALUES (15, 'опыт', 'опыт');


The row in target is


ID|TEST|TEST2
15|'опыт'|'опы'

Changes

 

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
Changes
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.