| DATA TYPE | SQL 92 | Oracle | MySQL | POSTGRE | MS 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 FLOAT4 FLOAT8 |
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 |
