Equivalent ANSI SQL Data Types

See Also   

The following table lists ANSI SQL data types and the equivalent Microsoft Jet database engine SQL data types and their valid synonyms.


ANSI SQL data type
Microsoft Jet
SQL data type

Synonym
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 (See Notes)  

Notes