Data Types
The Simba Amazon Redshift JDBC Driver supports many common data formats, converting between Redshift, SQL, and Java data types.
The following table lists the supported data type mappings.
| Redshift Type | SQL Type | Java Type |
|---|---|---|
|
BIGINT |
SQL_BIGINT |
Long |
|
BOOLEAN |
SQL_BIT |
Boolean |
|
CHAR |
SQL_CHAR |
String |
|
DATE |
SQL_TYPE_DATE |
java.sql.Date |
|
DECIMAL |
SQL_NUMERIC |
BigDecimal |
|
DOUBLE PRECISION |
SQL_DOUBLE |
Double |
|
GEOMETRY |
SQL_LONGVARBINARY |
byte[] |
|
INTEGER |
SQL_INTEGER |
Integer |
|
OID |
SQL_BIGINT |
Long |
|
REAL |
SQL_REAL |
Float |
|
SMALLINT |
SQL_SMALLINT |
Short |
| SUPER | SQL_LONGVARCHAR | String |
|
TEXT |
SQL_VARCHAR |
String |
| TIME | SQL_TYPE_TIME | java.sql.Time |
| TIMETZ | SQL_TYPE_TIME | java.sql.Time |
|
TIMESTAMP |
SQL_TYPE_TIMESTAMP |
java.sql.Timestamp |
|
TIMESTAMPTZ |
SQL_TYPE_TIMESTAMP |
java.sql.Timestamp |
|
VARCHAR |
SQL_VARCHAR |
String |