The Devart ODBC Driver for Zoho Books supports all Zoho Books data types.
The following table describes how the Zoho Books data types are mapped to the ODBC data types.
Zoho Books 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 |