Adapter Online Help > TDV Microsoft Access Adapter > Data Type Mappings > Microsoft Access Cache Mapping
 
Microsoft Access Cache Mapping
Microsoft Access does not have a TIME data type.
The data type mappings for caches stored on Microsoft Access are as follows.
Data Type
Native Type
BIGINT
DECIMAL(20,0)
BINARY
LONGBINARY
BIT
BIT
BLOB
LONGBINARY
CHAR
VARCHAR(n)
CLOB
LONGCHAR
DATE
DATETIME
DECIMAL
DECIMAL(p,s)
DOUBLE
DOUBLE
FLOAT
FLOAT
INTEGER
INTEGER
INTERVAL DAY
VARCHAR(30)
INTERVAL DAY TO HOUR
VARCHAR(30)
INTERVAL DAY TO MINUTE
VARCHAR(30)
INTERVAL DAY TO SECOND
VARCHAR(30)
INTERVAL HOUR
VARCHAR(30)
INTERVAL HOUR TO MINUTE
VARCHAR(30)
INTERVAL HOUR TO SECOND
VARCHAR(30)
INTERVAL MINUTE
VARCHAR(30)
INTERVAL MINUTE TO SECOND
VARCHAR(30)
INTERVAL MONTH
VARCHAR(9)
INTERVAL SECOND
VARCHAR(30)
INTERVAL YEAR
VARCHAR(9)
INTERVAL YEAR TO MONTH
VARCHAR(12)
NUMERIC
DECIMAL(p,s)
REAL
FLOAT
SMALLINT
SMALLINT
TIMESTAMP
DATETIME
TINYINT
BYTE
VARBINARY
LONGBINARY
VARCHAR
VARCHAR(n)