Created 2/25/2015 Last Updated: 9/25/2016
The following is the data type mapping for Oracle GoldenGate replication between Oracle and Informix IDS database.
Informix | Oracle |
---|---|
BOOL | RAW,BLOB |
CLOB | CLOB |
BLOB | BLOB |
CHAR with length <=2000 | CHAR |
CHAR with length > 2000 | CLOB |
VARCHAR, max length 255 | VARCHAR2 |
DATE | DATE |
DATETIME | TIMESTAMP, DATE |
INTERVAL | No Support |
DECIMAL | NUMBER |
FLOAT | NUMBER |
SMALLFLOAT | NUMBER |
SMALLINT | NUMBER |
INT8 (INTEGER) | NUMBER |
BIGINT | NUMBER |
LVARCHAR | CLOB |
MONEY | NUMBER |
SERIAL | NUMBER |
SERIAL8 | NUMBER |
BIGSERIAL | NUMBER |
NCHAR | NCHAR, max length allowed is 2000 |
NVARCHAR, max length 255 | NVARCHAR2 |
BYTE | LONG RAW,BLOB |
TEXT | CLOB |
HTML | CLOB |