The following table lists native data types supported by the driver and how they are mapped to ODBC data types.

Table 1. Dynamics 365 Data Types
Dynamics 365 Data Type ODBC Data Type
BINARY SQL_VARBINARY
BOOLEAN SQL_BIT
BYTE SQL_SMALLINT
DATE SQL_TYPE_DATE
DATETIMEOFFSET SQL_TYPE_TIMESTAMP
DECIMAL SQL_DECIMAL
DOUBLE SQL_DOUBLE
ENUM SQL_VARCHAR
GUID SQL_CHAR
INT16 SQL_SMALLINT
INT32 SQL_INTEGER
INT64 SQL_BIGINT
SBYTE SQL_TINYINT
SINGLE SQL_REAL
STRING SQL_VARCHAR
TIMEOFDAY SQL_TYPE_TIME