Supported data types

The following table describes the mapping between the Dynamics 365 and ODBC data types.

Dynamics 365 data type	ODBC data type
`BINARY`	`SQL_VARBINARY`
`BOOLEAN`	`SQL_BIT`
`DATETIME`	`SQL_TYPE_TIMESTAMP`
`DATE`	`SQL_TYPE_DATE`
`DECIMAL`	`SQL_DECIMAL`
`DOUBLE`	`SQL_FLOAT` `SQL_DOUBLE`
`GUID`	`SQL_GUID`
`INT`	`SQL_INTEGER`
`LONG`	`SQL_BIGINT`
`STRING`	`SQL_VARCHAR` `SQL_LONGVARCHAR` `SQL_WVARCHAR` `SQL_WLONGVARCHAR`
`TIME`	`SQL_TYPE_TIME`