JDBC Driver for Microsoft Access

Build 22.0.8462

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
ID long
Text string
Memo string
Byte tinyint
Integer int
Long long
Single float
Double float
Currency decimal
Date/Time datetime
Yes/No bool

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462