Data types conversions - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Data types conversions

The Amazon Redshift ODBC driver version 2.x supports many common data formats, converting between Amazon Redshift and SQL data types.

The following table lists the supported data type mappings.

Amazon Redshift type SQL type

BIGINT

SQL_BIGINT

BOOLEAN

SQL_BIT

CHAR

SQL_CHAR

DATE

SQL_TYPE_DATE

DECIMAL

SQL_NUMERIC

DOUBLE PRECISION

SQL_DOUBLE

GEOGRAPHY

SQL_ LONGVARBINARY

GEOMETRY

SQL_ LONGVARBINARY

INTEGER

SQL_INTEGER

REAL

SQL_REAL

SMALLINT

SQL_SMALLINT

SUPER

SQL_LONGVARCHAR

TEXT

SQL_LONGVARCHAR

TIME

SQL_TYPE_TIME

TIMETZ

SQL_TYPE_TIME

TIMESTAMP

SQL_TYPE_ TIMESTAMP

TIMESTAMPTZ

SQL_TYPE_ TIMESTAMP

VARBYTE

SQL_LONGVARBINARY

VARCHAR

SQL_VARCHAR