Unicode category - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869
Note: Columns with a Unicode datatype can only be mapped to applicable Unicode columns.

Unicode may be used in a distribution key.

Unicode data may be replicated among heterogeneous databases. Examples of this replication among heterogeneous databases are: DB2 Unicode to DB2 Unicode, DB2 Unicode to MS SQL Server Unicode (nchar and nvarchar) or DB2 Unicode to Oracle Unicode (nchar and nvarchar).

Connect CDC has two Unicode categories: Unicode and Long Unicode. Information about the supported Unicode datatype mappings are shown in the following tables. DBMSs are abbreviated in the tables as follows:

The following table shows the mappings that are supported for Unicode. Note that:

  • -> <- show direction

  • -> can be either source or target

  • If datatypes are equal, -> implies <->

  • n = length at source

  • m = length at target

Note: A mapping cannot be a distribution key in bidirectional replication if the lengths of the two datatypes are not identical.

Databases

Datatype

What happens...

Informix and Informix

NCHAR(n) -> NCHAR(m)

  • n > m–Warning at model creation and truncation at runtime.

  • n <= m–No warning generated and fills with pad character if necessary.

NVARCHAR(n) -> NVARCHAR(m)

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated.

 

NCHAR(n) <-> NVARCHAR(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated and fills with pad character if necessary.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated.

 

Informix and Oracle

NCHAR(n) -> NCHAR(m)

  • n > m–Warning at model creation and truncation at runtime.

  • n <= m–No warning generated and fills with pad character if necessary.

NVARCHAR(n) <-> NVARCHAR2(m)

  • n > m–Warning at model validation and truncation if the replicated value > m.

 

NCHAR(n) <-> NVARCHAR2(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated. and fills with pad if necessary.

 

NVARCHAR(n) <-> NCHAR(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated and fills with pad character if necessary.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated.

 

MS SQL Server and MS SQL Server

NCHAR(n) -> NCHAR(m)

  • n > m–Warning at model creation and truncation at runtime.

  • n <= m–No warning generated and fills with pad character if necessary.

NVARCHAR(n) -> NVARCHAR(m)

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated.

 

NTEXT -> NTEXT

 

 

NCHAR(n) <-> NVARCHAR(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated and fills with pad character if necessary.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated.

 

NCHAR(n) <-> NTEXT

  • ->–No warning generated.

  • <-–Warning during model validation and truncation at runtime.

 

NVARCHAR(n) <-> NTEXT

  • ->–No warning generated.

  • <-–Warning during model validation and truncation at runtime.

 

DB2/400 and DB2/400

GRAPHIC(n) -> GRAPHIC(m)

  • n > m–Warning at model creation and truncation at runtime.

  • n <= m–No warning generated and fills with pad character if necessary.

VARGRAPHIC(n) -> VARGRAPHIC(m)

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated.

 

GRAPHIC(n) <-> VARGRAPHIC(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated and fills with pad character if necessary.

 

MS SQL Server

NCHAR(n) -> NCHAR(m)

  • n > m–Warning at model creation and truncation at runtime.

  • n <= m–No warning generated and fills with pad character if necessary.

NVARCHAR(n) <-> NVARCHAR2(m)

  • n > m–Warning at model validation and truncation if the replicated value > m.

 

NCHAR(n) <-> NVARCHAR2(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated.

<-

  • m > n–Warning at model validation and truncation if the replicated value > m.

  • m <= n–No warning generated and fills with pad if necessary.

 

NVARCHAR(n) <-> NCHAR(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated and fills with pad character if necessary.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated.

 

NTEXT <-> NVARCHAR2(n)

  • ->–Warning during model validation and truncation at runtime if actual length > n.

  • <-–Does not generate a warning.

 

NTEXT <-> NCHAR(n)

  • ->–Warning during model validation and truncation at runtime if actual length > n.

  • <-–No warning generated.

 

MS SQL Server to and from DB2/400

NCHAR(n) <-> GRAPHIC(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated and fills with pad character if necessary.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated and fills with a pad character.

NVARCHAR(n) <-> VARGRAPHIC(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated.

 

NCHAR(n) <-> VARGRAPHIC(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m<=n–No warning generated and fills with a pad character.

 

NVARCHAR(n) <-> GRAPHIC(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated and fills with pad character if necessary.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated.

 

NTEXT <-> GRAPHIC(n)

  • ->–Warning at model validation and truncation at runtime if > n.

  • <-–No warning generated.

 

NTEXT <-> VARGRAPHIC(n)

  • ->–Warning at model validation and truncation at runtime.

  • <-–No warning generated.

 

DB2/400

NCHAR(n) <-> GRAPHIC(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated and fills with pad character if necessary.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated.

NVARCHAR2(n) <-> VARGRAPHIC(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated.

 

NCHAR(n) <-> VARGRAPHIC(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–No warning generated.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated and fills with pad if necessary.

 

NVARCHAR2(n) <-> GRAPHIC(m)

->

  • n > m–Warning at model validation and truncation if the replicated value > m.

  • n <= m–Does not generate a warning and fills with pad character if necessary.

<-

  • m > n–Warning at model validation and truncation if the replicated value > n.

  • m <= n–No warning generated.