| Domini ANSI SQL | Domini Microsoft Jet SQL | Sinonimi |
|---|
| BIT, BIT VARYING | BINARY (See Notes) | VARBINARY |
| Not supported | BIT (See Notes) | BOOLEAN, LOGICAL, LOGICAL1, YESNO |
| Not supported | BYTE | INTEGER1 |
| Not supported | COUNTER | AUTOINCREMENT |
| Not supported | CURRENCY | MONEY |
| DATE, TIME, TIMESTAMP | DATETIME | DATE, TIME, TIMESTAMP |
| Not supported | GUID | |
| DECIMAL | Not supported | |
| REAL | SINGLE | FLOAT4, IEEESINGLE, REAL |
| DOUBLE PRECISION, FLOAT | DOUBLE | FLOAT, FLOAT8, IEEEDOUBLE, NUMBER, NUMERIC |
| SMALLINT | SHORT | INTEGER2, SMALLINT |
| INTEGER | LONG | INT, INTEGER, INTEGER4 |
| INTERVAL | Not supported | |
| Not supported | LONGBINARY | GENERAL, OLEOBJECT |
| Not supported | LONGTEXT | LONGCHAR, MEMO, NOTE |
| CHARACTER, CHARACTER VARYING | TEXT | ALPHANUMERIC, CHAR, CHARACTER, STRING, VARCHAR |
| Not supported | VALUE (Vedi note) | |
Note:
- Il dominio BIT dell'ANSI SQL non corrisponde al BIT di Jet SQL, bensė al dominio (tipo di dato) BINARY.
Nell'ANSI SQL non ci sono domini equivalenti al BIT di Jet SQL.
- La parola riservata VALUE non č un dominio (tipo di dati) definito nel motore di Microsoft Jet.
The VALUE reserved word doesn't represent a data type defined by the Microsoft Jet database engine.
|