The table below displays each Connect CDC datatype category and the categories to which it can be converted. The pages that follow contain sections for each category showing specific details by datatype and DBMS. These sections include exceptions to the general rules displayed in the table below.
Use the following key to interpret the information in the table below. “Display length” and “numeric length” are as defined for the tables on page 121 through page 318.
|
Abbreviation... |
Equals... |
|---|---|
|
rl |
display length, receiving column |
|
sl |
display length, sending column |
|
rnl |
numeric length, receiving column |
|
snl |
numeric length, sending column |
|
rp |
precision, receiving column |
|
sp |
precision, sending column |
|
rs |
scale, receiving column |
|
ss |
scale, sending column |
|
Converting from/to |
Character or Long Character (rl) |
Date/Interval |
ApproximateNumeric |
IntegralNumeric |
DecimalNumeric |
Binary or Long Binary |
Unicode or Long Unicode |
|---|---|---|---|---|---|---|---|
|
Character or Long Character (sl) |
Yes(if sl > rl andchar -> char, warning on char, error on long char) |
No |
No |
No |
No |
No |
Some a |
|
Date/Interval |
Yes(if rl >= sl) |
Yes b |
No |
No |
No |
No |
No |
|
Approximate Numeric |
Yes(if rl >= 22) |
No |
Yes |
Yes c |
Yes |
No |
No |
|
Integral Numeric |
Yes(if rl >= snl) |
No |
Yes |
Yes |
Yes(warn ifrp-rs < snl) |
No |
No |
|
Decimal Numeric (sp, ss) |
Yes |
No |
Yes |
Yes(warn and truncate if sp-ss > rnl) |
Yes(warn ifsp > rp or if ss > rs) |
No |
No |
|
Binary orLong Binary |
No |
No |
No |
No |
No |
Some d |
No |
|
Unicode or Long Unicode |
No |
No |
No |
No |
No |
No |
Some a |
|
aSee Unicode Category . bSee Date/Interval Category . cOnly to INTEGER or NUMBER(38) datatypes. dSee Binary Categories. |