Mirror Replication Agent processes Oracle transactions and passes data to the primary Replication Server. In turn, the primary Replication Server uses the datatype formats specified in the replication definition to receive the data from Mirror Replication Agent.
Table C-2 describes the conversion of Oracle datatypes to Sybase datatypes.
Oracle datatype |
Oracle length/range |
Sybase datatype |
Sybase length/range |
Notes |
|---|---|---|---|---|
CHAR |
255 bytes |
char |
32K |
|
DATE |
8 bytes, fixed-length, default format: DD-MON-YY |
rs_oracle_ datetime |
8 bytes |
Replication Server supports dates from January 1, 1753 to December 31, 9999. Oracle supports dates from January 1, 4712 BC to December 31, 4712 AD. The default value replicated is: MM/DD/YYYY HH24:MI:SS. If pdb_convert_datetime is true, the value replicated is YYYYMMDD HH:MM:SS.sss. |
TIMESTAMP(n) |
21-31 bytes, variable-length, default format: DD-MON-YY hh.mm.ss.ffffff AM |
rs_oracle_ datetime9 |
8 bytes |
Replication Server supports dates from January 1, 1753 to December 31, 9999. Oracle supports dates from January 1, 4712 BC to December 31, 4712 AD. Default format is DD-MON-YY HH.MI.SS.FF AM. |
TIMESTAMP(n) WITH [LOCAL] TIME ZONE |
Variable-length, default format: DD-MON-YY hh.mm.ss.ffffff AM {+|-}hh:mm |
rs_oracle_ timestamptz |
||
INTERVAL YEAR(n) TO MONTH |
Variable-length |
rs_oracle_ interval |
||
INTERVAL DAY(n) TO SECOND(n) |
Variable-length |
rs_oracle_ interval |
||
LONG |
2GB, variable-length character data |
text |
|
|
LONG RAW |
2GB, variable-length binary data |
image |
|
|
BLOB |
4GB, variable-length binary large object |
image |
|
|
CLOB |
4GB, variable-length character large object |
text |
|
|
NCHAR |
255 bytes, multibyte characters |
unichar or char |
32K |
|
NCLOB |
4GB, variable-length multibyte character large object |
text |
||
NVARCHAR2 |
2000 bytes, variable-length, multibyte character data |
univarchar or varchar |
32K |
|
BFILE |
4GB, locator points to large binary file |
image |
Not supported. |
|
MLSLABEL |
5 bytes, variable-length binary OS label |
Not supported. |
||
NUMBER (p,s) |
21 bytes, variable-length numeric data |
rs_oracle_ decimal |
float is 4 or 8 bytes. int is 4 bytes. real is 4 bytes. number and decimal are 2 to 17 bytes. |
The float datatype can convert to scientific notation if the range is exceeded. Integers (int) are truncated if they exceed the Replication Server range of 2,147,483,647 to -2,147,483,648, or 1x10-130 to 9.99x1025. The number and decimal datatypes are truncated if they exceed the range of -1038 to 1038-1. Oracle precision ranges from 1 to 38 digits. Default precision is 18 digits. Oracle scale ranges from -84 to 127. Default scale is 0. |
RAW |
2000 bytes, variable-length binary data |
rs_oracle_ raw |
32K |
|
ROWID |
6 bytes, binary data representing row addresses |
rs_oracle_ rowid |
32K |
|
UDD object type |
variable length character data |
rs_rs_char_ raw |
32K |
|
VARCHAR2 |
4000 bytes, variable-length character data |
varchar |
32K |
