column types

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