|
ODBC Driver for Microsoft Access Supported Data Types - ODBC Driver for Microsoft Access |
|
|
|
ODBC Driver for Microsoft Access Supported Data Types - ODBC Driver for Microsoft Access |
|
The Devart ODBC Driver for Microsoft Access supports all Microsoft Access data types.
The following table describes how the Microsoft Access data types are mapped to the ODBC data types.
| Microsoft Access Data Types | ODBC Data Types |
|---|---|
|
SHORT TEXT |
SQL_VARCHAR |
|
LONG TEXT |
SQL_LONGVARCHAR |
|
BYTE |
SQL_TINYINT |
|
INTEGER |
SQL_SMALLINT |
|
LONG |
INTEGER SQL_INTEGER |
|
LARGE |
NUMBER SQL_BIGINT |
|
SINGLE |
SQL_REAL |
|
DOUBLE |
SQL_DOUBLE |
|
NUMBER |
SQL_DECIMAL |
|
CURRENCY |
SQL_DOUBLE |
|
DATE/TIME |
SQL_TYPE_TIMESTAMP |
|
DATE/TIME EXTENDED |
SQL_TYPE_TIMESTAMP |
|
YES/NO |
SQL_BIT |
|
OLE OBJECT |
SQL_LONGVARBINARY |