DBMS DATA TYPE
2009/08/08 01:29
瀏覽686
迴響0
推薦0
引用0
DBMS DATA TYPE
| DATA TYPE | SQL 92 | Oracle | MySQL | POSTGRE | M$ SQL | Common |
| BOOLEAN | BOOLEAN | BOOL | ||||
| CHARACTER | CHAR | CHAR | CHAR VARCHAR BLOB 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 PRECISIONFLOAT4FLOAT8 | 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 |
你可能會有興趣的文章：
