|
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
|