|
ODBC Driver for Dynamics 365 Business Central Supported Data Types - ODBC Driver for Dynamics 365 Business Central |
|
|
|
ODBC Driver for Dynamics 365 Business Central Supported Data Types - ODBC Driver for Dynamics 365 Business Central |
|
The Devart ODBC Driver for Dynamics 365 Business Central supports all Dynamics 365 Business Central data types.
The following table describes how the Dynamics 365 Business Central data types are mapped to the ODBC data types.
| Dynamics Data Types | ODBC Data Types |
|---|---|
|
BINARY |
SQL_VARBINARY |
|
STRING |
SQL_VARCHAR |
|
SQL_LONGVARCHAR |
|
|
SQL_WVARCHAR |
|
|
SQL_WLONGVARCHAR |
|
|
BOOLEAN |
SQL_BIT |
|
INT |
SQL_INTEGER |
|
LONG |
SQL_BIGINT |
|
DOUBLE |
SQL_FLOAT |
|
SQL_DOUBLE |
|
|
DECIMAL |
SQL_DECIMAL |
|
TIME |
SQL_TYPE_TIME |
|
DATE |
SQL_TYPE_DATE |
|
DATETIME |
SQL_TYPE_TIMESTAMP |
|
GUID |
SQL_GUID |