skip to main content
Supported data types : Amazon Redshift data types
 

Try DataDirect Cloud Now

Amazon Redshift data types

The following table shows how the Amazon Redshift data types are mapped to the standard JDBC and ODBC data types.
Table 1. Amazon Redshift Data Types
Amazon Redshift data type
JDBC data type
ODBC data type
BIGINT
BIGINT
SQL_BIGINT
BOOLEAN
Boolean
SQL_BIT
CHARACTER
CHAR
SQL_CHAR
CHARACTER VARYING
VARCHAR or LONGVARCHAR
SQL_VARCHAR or SQL_LONGVARCHAR
DATE
DATE
SQL_TYPE_DATE
DOUBLE PRECISION
DOUBLE
SQL_DOUBLE
INTEGER
INTEGER
SQL_INTEGER
Numeric1
NUMERIC
SQL_NUMERIC
REAL
REAL
SQL_REAL
SMALLINT
SMALLINT
SQL_SMALLINT
TIMESTAMP
TIMESTAMP
SQL_TYPE_TIMESTAMP

1 Numeric maps to SQL_NUMERIC if the precision of the Numeric is less than or equal to 38. If the precision is greater than 38, the connectivity service maps the column to SQL_VARCHAR.