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