ODBC Driver for Dynamics

Supported Data Types



Devart ODBC Driver for Dynamics CRM supports all the Dynamics data types.

The complete list of Dynamics data types is available in the Dynamics documentation.

Data Type Mapping

The following table describes how ODBC data types are mapped to Dynamics 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

© 2015-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback