ODBC Driver for Google BigQuery

Supported Data Types - ODBC Driver for Google BigQuery



Data Type Mapping

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

© 2015-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback