DBMS DATA TYPE
DATA TYPE | SQL 92 | Oracle | MySQL | POSTGRE | M$ SQL | Common |
BOOLEAN | BOOLEAN | BOOL | ||||
CHARACTER | CHAR VARCHAR | CHAR VARCHAR2 NVARCHAR2 LONG TEXT ENUM SET | CHAR VARCHAR BLOB TEXT ENUM SET | CHAR VARCHAR TEXT NAME CHARACTER | CHAR VARCHAR TEXT | CHAR VARCHAR TEXT |
BIT | BIT BIT VARYING | BIT | ||||
EXACT NUMERIC | INTEGER SMALLINT DECIMAL NUMERIC | INTEGER NUMBER NUMERIC SMALLINT DECIMAL | INTEGER SMALLINT DECIMAL NUMERIC | INTEGER DECIMAL INT2 INT4 INT8 NUMERIC SERIAL | INTEGER BIGINT SMALLINT TINYINT NUMERIC DECIMAL | INTEGER NUMERIC DECIMAL |
APPROXIMATE NUMERIC | FLOAT REAL DOUBLE PRECISION | FLOAT REAL DOUBLE PRECISION | FLOAT REAL DOUBLE PRECISION | FLOAT REAL DOUBLE PRECISION FLOAT4FLOAT8 | FLOAT REAL DOUBLE PRECISION | FLOAT REAL DOUBLE RECISION |
DATETIME | DATE TIME TIMESTAMP | DATE TIME DATETIME TIMESTAMP YEAR | DATE TIME DATETIME TIMESTAMP YEAR | DATE TIME TIMETZ TIMESTAMP CURRENT EPOCH INFINITY INVALID NOW TODAY TOMORROW YESTERDAY | DATE TIME SMALLDATATIME TIMESTAMP UNIQUEIDENTIFIER | TIMESTAMP DATE |
INTERVAL | INTERVAL | INTERVAL | ||||
BINARY | ROWID NROWID RAW LONG RAW | BINARY VARBINARY IMAGE | ||||
LARGE OBJECTS | CHARACTER LARGE OBJECTBINARY LARGE OBJECT | CHARACTER LARGE OBJECT BINARY LARGE OBJECT NATIONAL LARGE OBJECT | ||||
NET | CIDR INET | |||||
Geometric | BOX CIRCLE LINE LSEG PATH POINT POLYGON SERIAL |