Supported data types

The following table describes the mapping between Zoho CRM and ODBC data types.

Zoho CRM data type	ODBC data type
BINARY	SQL_VARBINARY
BOOLEAN	SQL_BIT
BYTE	SQL_TINYINT
DATE	SQL_TYPE_DATE
DATETIME	SQL_TYPE_TIMESTAMP
DOUBLE	SQL_FLOAT SQL_DOUBLE
INTEGER	SQL_INTEGER SQL_SMALLINT
STRING	SQL_VARCHAR SQL_LONGVARCHAR SQL_WVARCHAR SQL_WLONGVARCHAR
TIME	SQL_TYPE_TIME