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

Table 1. Aha! Data Types
Aha! 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