ODBC Driver for Amazon Redshift Supported Data Types - ODBC Driver for Amazon Redshift |
The Devart ODBC Driver for Amazon Redshift supports all Amazon Redshift data types.
The following table describes how the Amazon Redshift data types are mapped to the ODBC data types.
Amazon Redshift Data Types | ODBC Data Types |
---|---|
SMALLINT |
SQL_SMALLINT |
INTEGER |
SQL_INTEGER |
BIGINT |
SQL_BIGINT |
DECIMAL |
SQL_DECIMAL |
REAL |
SQL_REAL |
DOUBLE PROCISION |
DOUBLE PRECISION |
CHAR |
SQL_WVARCHAR |
NCHAR |
SQL_WVARCHAR |
BPCHAR |
SQL_WVARCHAR |
VARCHAR |
SQL_WVARCHAR |
NVARCHAR |
SQL_WVARCHAR |
TEXT |
SQL_WVARCHAR |
DATE |
SQL_TYPE_DATE |
TIMESTAMP |
SQL_TYPE_TIMESTAMP |
TIMESTAMPTZ |
SQL_TYPE_TIMESTAMP |