skip to main content
About the Driver : Progress DataDirect for JDBC for Amazon Redshift : Data Types
  

Data Types

The following table lists the data types supported by the driver and describes how they are mapped to JDBC data types.
Note: See getTypeInfo() for getTypeInfo() results for Amazon Redshift databases supported by the driver.
Table 3. Amazon Redshift Data Types
Data Type
JDBC Data Type
Bigint
BIGINT
Boolean
BOOLEAN
Character
CHAR
Character varying 1
VARCHAR
Date
DATE
Double precision
DOUBLE
Integer
INTEGER
Numeric
NUMERIC
Real
REAL
Smallint
SMALLINT
Timestamp
TIMESTAMP
1 You can determine how these columns are described by setting the VarcharClobThreshold connection property.