User guide

VARCHAR(n) VARCHAR
NCHAR VARYING VARCHAR
FLOAT[(n)] If n > 24 then DOUBLE else FLOAT
REAL FLOAT
DOUBLE PRECISION DOUBLE
DECIMAL[(n[,n])] DECIMAL
INTEGER[(n)] If n == 0 then INTEGER else NUMERIC
SMALLINT[(n)] If n == 0 then SMALLINT else NUMERIC
TINYINT[(n)] If n == 0 then TINYINT else NUMERIC
BIGINT[(n)] If n == 0 then BIGINT else NUMERIC
QUADWORD[(n)] If n == 0 then BIGINT else NUMERIC
DATE ANSI DATE
DATE VMS TIMESTAMP
TIME TIME
TIMESTAMP TIMESTAMP
INTERVAL BIGINT
BYTE VARYING VARBINARY
LIST OF BYTE VARYING BLOB
10.6 Datatype Mapping from java.sql.Types to Oracle Rdb
SQL Type (from java.sql.Types) Rdb SQL datatype
CHAR CHAR(n)
NCHAR NCHAR(n)
VARCHAR VARCHAR(n)
FLOAT REAL
DOUBLE DOUBLE PRECISION
DECIMAL DECIMAL[(n[,n])]
INTEGER INTEGER
SMALLINT SMALLINT
TINYINT TINYINT
BIGINT BIGINT
NUMERIC BIGINT(n)
DATE DATE ANSI
TIMESTAMP TIMESTAMP
161