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
Decimal¹	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_TIMESTAMP²
Tinyint	SQL_SMALLINT
Wchar	SQL_CHAR
Wvarchar	SQL_VARCHAR

¹ Numeric is an alias for Decimal.

² TimestampTZ mapping changes based on the setting of the Fetch TSWTZ as Timestamp option. The default is SQL_VARCHAR.