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 | bool |
| BYTE | tinyint |
| COUNTER | int |
| CURRENCY | decimal |
| DATETIME | datetime |
| DATETIME Extended | datetime |
| DOUBLE | float |
| GUID | uuid |
| LONG | int |
| LONGBINARY | binary |
| MEMO | varchar |
| SINGLE | real |
| SHORT | smallint |
| TEXT | varchar |
| BIGINT | bigint |