Oracle:
CHAR
VARCHAR2
NCHAR
NVARCHAR2
FLOAT
LONG
NUMBER
DATE
RAW
LONG RAW
BLOB
CLOB
NCLOB
BFILE
ROWID
UROWID
XMLTYPE
DB2:
SMALLINT SMALLINT 两字节整数 -32768 to 32767
INTEGER/INT INTEGER 四字节整数 -2147483648 TO 2147483647
BIGINT BIGINT 八字节整数 -9223372036854775808 TO 9223372036854775807
DECIMAL DECIMAL(P,S), DEC(P,S), NUMERIC(P,S), NUM(P,S) -10**31+1 TO 10**31+1
DOUBLE/DOUBLE PRECISION/FLOAT 六十四位实数 双精度浮点数 0 or -1.79769E+308 to -2.225E-307 or 2.225E-307 to 1.79769E+308
REAL 单精度浮点数 32位实数 0 or -3.402E+ 38 to -1.175E-37 or 1.175E-37 to 3.402E+308
CHARACTER/CHAR CHARACTER(n) or CHAR(n), CHARACTER = CHAR = CHARACTER(1) = CHAR(1) FROM 1 TO 254
VARCHAR VARCHAR(n)/CHARACTER VARYING(n)/CHAR VARRING(n) from 0B to 32672B
LONG VARCHAR LONG VARCHAR(n) from 0B to 32700B
BLOB bLOB(n[K|M|G]) from 0 to 2GB
CLOB CLOB(n[K|M|G]) from 0 to 2GB
GRAPHIC GRAPHIC(n) from 1 to 127双字节字符
VARGRAPHIC VARGRAPHIC(n) from 1 to 16336双字节
LONG VARGRAPHIC LONG VARGRAPHIC(n) from 1 to 16350双字节
DBCLOB DBCLOB(n[K|M|G]) FROM 0 TO 1GB
DATE 0001-01-01 TO 99991231 YYYY-MM-DD
TIME HH:MM:SS
TIMESTAMP YYYY-MM-DD-HH.MM.SS.NNNNNN
SQLSERVER:
BIGINT
BINARY
BIT
CHAR
DATETIME
DECIMAL
FLOAT
IMAGE
INT
MONEY
NCHAR
NTEXT
NUMERIC
NVARCHAR
REAL
SMAILLDATETIME
SMALLMONEY
SQL_VARIANT
TEXT
TIMESTAMP
TINYINT
UNIQUEIDENTIFIE
VARBINARY
VARCHAR