資料型態整理 Oracle, MySQL, PostgreSQL, M$ SQL - DBMS DATA TYPE

2021/12/25

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`P`RECISION`	FLOAT REAL `DOUBLE`P`RECISION`	FLOAT REAL `DOUBLE` P`RECISION`FLOAT4 FLOAT8	FLOAT REAL `DOUBLE` P`RECISION`	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