|
ODBC Driver for Google BigQuery Supported Data Types - ODBC Driver for Google BigQuery |
|
|
|
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 |