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