Supported Datatypes
Supported
The supported data types are:
NUMBER
- FLOAT
- VARCHAR2
- VARCHAR
- CHAR
- NVARCHAR2
- NCHAR2
- NCHAR
- DATE
- RAW
- LONG*
- LONG RAW*
- BFILE**
- CLOB**
- BLOB**
- LOB**
- NCLOB**
- INTERVAL **
- TIMESTAMP **
* Not supported in Oracle 9.2
** Not supported when replicating to MySQL or SQL Server
A SQL query can be run to determine if there are any datatypes that will not be supported by Dbvisit Replicate.
Data Type conversion on target DB
| Source | Target | |||
|---|---|---|---|---|
| Oracle | Oracle 9.2 | Oracle 10+ | MS SQL Server | MySQL |
| NUMBER | NUMBER | NUMBER | FLOAT or BIGINT(when scale==0) | FLOAT or BIGINT(when scale==0) |
| FLOAT | FLOAT | FLOAT | FLOAT | FLOAT |
| VARCHAR2 | VARCHAR2 | VARCHAR2 | VARCHAR | VARCHAR |
| VARCHAR | VARCHAR | VARCHAR | VARCHAR | VARCHAR |
| CHAR | CHAR | CHAR | CHAR | CHAR |
| NVARCHAR2 | NVARCHAR2 | NVARCHAR2 | VARCHAR | VARCHAR |
| NCHAR2 | NCHAR2 | NCHAR2 | VARCHAR | VARCHAR |
| NCHAR | NCHAR | NCHAR | VARCHAR | VARCHAR |
| DATE | DATE | DATE | DATETIME | DATETIME |
| RAW | RAW | RAW | VARBINARY | VARBINARY |
| LONG | x | LONG | TEXT | TEXT |
| LONG RAW | x | LONG RAW | BLOB | BLOB |
| BFILE | BFILE | BFILE | x | x |
| CLOB | CLOB | CLOB | x | x |
| BLOB | BLOB | BLOB | x | x |
| LOB | LOB | LOB | x | x |
| NCLOB | NCLOB | NCLOB | x | x |
| INTERVAL | INTERVAL | INTERVAL | x | x |
| TIMESTAMP | TIMESTAMP | TIMESTAMP | x | x |
Unsupported data types are listed here: Unsupported Datatypes
Unsupported functionality is listed here: Functionality Currently NOT Supported.