Jet(Ms Access) data types, synonyms and ANSI SQL equivalents
Jet SQL: BINARY ANSI SQL: BIT, BIT VARYING Synonym: VARBINARY Jet SQL: BIT ANSI SQL: Not supported Synonym: BOOLEAN, LOGICAL, LOGICAL1, YESNO Jet SQL: BYTE ANSI SQL: Not supported Synonym: INTEGER1 Jet SQL: COUNTER ANSI SQL: Not supported Synonym: AUTOINCREMENT Jet SQL: CURRENCY ANSI SQL: Not supported Synonym: MONEY Jet SQL: DATETIME ANSI SQL: DATE, TIME, TIMESTAMP Synonym: DATE, TIME, TIMESTAMP Jet SQL: GUID ANSI SQL: Not supported Jet SQL: SINGLE ANSI SQL: REAL Synonym: FLOAT4, IEEESINGLE, REAL Jet SQL: DOUBLE ANSI SQL: DOUBLE PRECISION, FLOAT Synonym: FLOAT, FLOAT8, IEEEDOUBLE, NUMBER, NUMERIC Jet SQL: SHORT ANSI SQL: SMALLINT Synonym: INTEGER2, SMALLINT Jet SQL: LONG ANSI SQL: INTEGER Synonym: INT, INTEGER, INTEGER4 Jet SQL: LONGBINARY ANSI SQL: Not supported Synonym: GENERAL, OLEOBJECT Jet SQL: LONGTEXT ANSI SQL: Not supported Synonym: LONGCHAR, MEMO, NOTE Jet SQL: TEXT ANSI SQL: CHARACTER, CHARACTER VARYING Synonym: ALPHANUMERIC, CHAR, CHARACTER, STRING, VARCHAR Jet SQL: VALUE ANSI SQL: Not supported ANSI SQL DECIMAL and INTERVAL are not supported in Jet SQL.
Compiled from various (public domain) sources.