EXP Computer ThinConnect4 Uživatelská příručka stáhnout pdf (Strana 161)

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

1 2 ... 156 157 158 159 160 161 162 163

Žádné komentáře

EXP Computer ThinConnect4 Uživatelská příručka Strana 161