The Devart ODBC Driver for Zoho CRM supports all Zoho CRM data types.
The following table describes how the Zoho CRM data types are mapped to the ODBC data types.
Zoho CRM Data Types | ODBC Data Types |
---|---|
BINARY |
SQL_VARBINARY |
STRING |
SQL_VARCHAR |
SQL_LONGVARCHAR |
|
SQL_WVARCHAR |
|
SQL_WLONGVARCHAR |
|
BOOLEAN |
SQL_BIT |
BYTE |
SQL_TINYINT |
INTEGER |
SQL_INTEGER |
SQL_SMALLINT |
|
DOUBLE |
SQL_FLOAT |
SQL_DOUBLE |
|
TIME |
SQL_TYPE_TIME |
DATE |
SQL_TYPE_DATE |
DATETIME |
SQL_TYPE_TIMESTAMP |