Unicode category - connect_cdc_mimix_share

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.

Unicode category - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide