|
ODBC Driver for Amazon Redshift Supported Data Types - ODBC Driver for Amazon Redshift |
|
|
|
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 |