The following table shows how the Amazon Redshift data types are mapped to the standard ODBC data types.

Table 1. Amazon Redshift Data Types
Amazon Redshift ODBC
Bigint SQL_BIGINT
Boolean SQL_BIT
Character SQL_CHAR
Varchar SQL_VARCHAR
Date SQL_TYPE_DATE
Decimal1 SQL_NUMERIC
Double Precision SQL_DOUBLE
Float SQL_REAL
Integer SQL_INTEGER
Real SQL_REAL
Smallint SQL_SMALLINT
Timestamp SQL_TYPE_TIMESTAMP
TimestampTZ SQL_VARCHAR | SQL_TYPE_TIMESTAMP2
Tinyint SQL_SMALLINT
Wchar SQL_CHAR
Wvarchar SQL_VARCHAR
1 Numeric is an alias for Decimal.
2 TimestampTZ mapping changes based on the setting of the Fetch TSWTZ as Timestamp option. The default is SQL_VARCHAR.