Character and long character categories  - 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

Connect CDC has two character categories: Character and Long Character. Most of the currently supported DBMS character datatypes are classified as Character. Datatypes designed for large character objects belong to the Long Character category.

You can convert Character or Long Character datatypes only to datatypes in the Character or Long Character categories, as shown in the table below.

Note: In all of the conversions that have a character target type, Connect CDC truncates source column data (from the right) to fit the defined target column length. Values too long for Long Character targets cause an error