13.2.7.Data type mappings

Heterogeneous replication requires data type mapping to be performed when Virtuoso table is created on replica.

Table13.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