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


DBMS DATA TYPE

DATA TYPESQL 92OracleMySQLPOSTGREM$ SQLCommon
BOOLEANBOOLEANBOOL
CHARACTERCHAR
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
BITBIT
BIT VARYING
BIT
EXACT NUMERICINTEGER
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 NUMERICFLOAT
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
DATETIMEDATE
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
INTERVALINTERVAL INTERVAL
BINARYROWID
NROWID
RAW
LONG RAW
BINARY
VARBINARY
IMAGE
LARGE OBJECTSCHARACTER LARGE OBJECTBINARY LARGE OBJECTCHARACTER LARGE OBJECT BINARY LARGE OBJECT NATIONAL LARGE OBJECT
NETCIDR
INET
GeometricBOX
CIRCLE
LINE
LSEG
PATH
POINT
POLYGON
SERIAL

這是真的廣告

白金贊助

平價童鞋首選