Data Type Mapping
Data Type Mappings
The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
| Microsoft Access | CData Schema |
| BOOLEAN | BIT |
| BYTE | TINYINT |
| COUNTER | INT |
| CURRENCY | DECIMAL |
| DATETIME | TIMESTAMP |
| DATETIME Extended | TIMESTAMP |
| DOUBLE | FLOAT |
| GUID | UUID |
| LONG | INT |
| LONGBINARY | BINARY |
| MEMO | VARCHAR |
| SINGLE | REAL |
| SHORT | SMALLINT |
| TEXT | VARCHAR |
| BIGINT | BIGINT |