The following table lists native data types supported by the driver and how they are mapped to ODBC data types.

Table 1. Google Analytics 4 Driver Data Types
Google Analytics 4 Driver Data Type ODBC Data Type
BigInt SQL_BIGINT
Binary SQL_BINARY
Bit SQL_BIT
Boolean SQL_BIT
Char SQL_CHAR
Date SQL_TYPE_DATE
Decimal SQL_DECIMAL
Double SQL_DOUBLE
Float SQL_FLOAT
GUID SQL_CHAR
Integer SQL_INTEGER
JSON SQL_VARCHAR
LongVarBinary SQL_LONGVARBINARY
LongVarChar SQL_LONGVARCHAR
NVarChar SQL_UNICODE_VARCHAR
SmallInt SQL_SMALLINT
Time SQL_TYPE_TIME
Timestamp SQL_TYPE_TIMESTAMP
TinyInt SQL_TINYINT
VarBinary SQL_VARBINARY
VarChar SQL_VARCHAR