Supported Data Types
Supported Types
The CData ODBC Driver for Google Sheets supports the following data types as column values:
CData Schema | ODBC Data Type |
string | SQL_CHAR |
string | SQL_VARCHAR |
string | SQL_LONGVARCHAR |
short | SQL_SMALLINT |
int | SQL_INTEGER |
long | SQL_BIGINT |
float | SQL_REAL |
double | SQL_DOUBLE |
decimal | SQL_DECIMAL |
boolean | SQL_BIT |
datetime | SQL_TYPE_TIMESTAMP |
datetime | SQL_TIMESTAMP |
time | SQL_TYPE_TIME |
time | SQL_TIME |