ODBC Driver for Google BigQuery Supported Data Types - ODBC Driver for Google BigQuery |
The Devart ODBC Driver for Google BigQuery supports all Google BigQuery data types.
The following table describes how the Google BigQuery data types are mapped to the ODBC data types.
BigQuery Data Types | ODBC Data Types |
---|---|
INT64 |
SQL_BIGINT |
STRING |
SQL_VARCHAR |
SQL_LONGVARCHAR |
|
SQL_WVARCHAR |
|
SQL_WLONGVARCHAR |
|
NUMERIC |
SQL_NUMERIC |
SQL_DECIMAL |
|
FLOAT64 |
SQL_DOUBLE |
BOOL |
SQL_BIT |
BYTES |
SQL_VARBINARY |
DATE |
SQL_TYPE_DATE |
DATETIME |
SQL_TYPE_TIMESTAMP |
TIMESTAMP |
SQL_TYPE_TIMESTAMP |
TIME | SQL_TYPE_TIME |
ARRAY |
SQL_VARCHAR |
STRUCT |
SQL_VARCHAR |
GEOGRAPHY |
SQL_VARCHAR |
SQL_WVARCHAR |