¶
13.2.7. Data type mappings
Heterogeneous replication requires data type mapping to be performed when Virtuoso table is created on replica.
Table 13.1. Data type mappings
| Virtuoso | SQL Server | Oracle | DB2 | Informix |
| varchar | varchar(8000) | VARCHAR2(4000) | VARCHAR(32000) | VARCHAR(254) |
| varchar(n) | varchar(n) | VARCHAR2(n) | VARCHAR(n) | VARCHAR(n) |
| integer | int | INTEGER | INTEGER | INTEGER |
| smallint | smallint | SMALLINT | SMALLINT | SMALLINT |
| real | real | FLOAT | REAL | SMALLFLOAT |
| double precision | float | DOUBLE PRECISION | DOUBLE | FLOAT |
| numeric | numeric(38, 15) | NUMERIC(38, 15) | NUMERIC(32, 15) | DECIMAL(31, 15) |
| numeric(p, s) | numeric(p, s) | NUMERIC(p, s) | NUMERIC(p, s) | DECIMAL(p, s) |
| date | datetime | DATE | DATE | DATE |
| time | datetime | DATE | TIME | DATETIME HOUR TO SECOND |
| datetime, timestamp | datetime | DATE | TIMESTAMP | DATETIME YEAR TO FRACTION(5) |
| varbinary | varbinary(8000) | RAW(2000) | VARCHAR(32000) FOR BIT DATA | BYTE |
| varbinary(n) | varbinary(n) | RAW(n) | VARCHAR(n) FOR BIT DATA | BYTE |
| long varbinary | image | BLOB | BLOB | BYTE |
| long varchar | text | CLOB | CLOB | TEXT |
| nvarchar | nvarchar(4000) | NVARCHAR2(4000) | VARCHAR(32000) FOR MIXED DATA | NVARCHAR(254) |
| nvarchar(n) | nvarchar(n) | NVARCHAR2(n) | VARCHAR(n) FOR MIXED DATA | NVARCHAR(n) |
| long nvarchar | ntext | NCLOB | DBCLOB | TEXT |