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


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

Facebook 留言

廣告

樂樂童鞋