|
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 |
|---|---|
|
BOOLEAN |
SQL_BIT |
|
BYTE |
SQL_SMALLINT |
|
SHORT |
SQL_SMALLINT |
|
INT |
SQL_INTEGER |
|
LONG |
SQL_BIGINT |
|
FLOAT |
SQL_REAL |
|
DOUBLE |
SQL_DOUBLE |
|
TIMESTAMP |
SQL_TYPE_TIMESTAMP |
|
DATE |
SQL_TYPE_TIMESTAMP |
|
CHAR |
SQL_PG_CHARACTER |
|
SYMBOL |
SQL_PG_VARCHAR |
|
LONG256 |
SQL_VARCHAR |
|
STRING |
SQL_PG_VARCHAR |
|
BINARY |
SQL_LONGVARBINARY |