資料庫型態比較

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
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
 
 
來源：資料型態整理 Oracle, MySQL, PostgreSQL, M$ SQL - DBMS DATA TYPE - Soul & Shell Blog (toright.com)