The following table lists the data types supported by the Denodo driver and describes how they are mapped to JDBC data types.

Table 1. Denodo Data Types
Denodo Data Type JDBC Data Type
Blob BLOB or BINARY or VARBINARY or LONGVARBINARY
Boolean BOOLEAN or BIT
Decimal DECIMAL or NUMERIC
Double DOUBLE
Float FLOAT or REAL
Int INTEGER or SMALLINT or TINYINT
Localdate DATE
Long BIGINT
Text VARCHAR or CHAR or LONGVARCHAR
Time TIME
Timestamp TIMESTAMP
Timestamptz TIMESTAMP_WITH_TIMEZONE
XML SQLXML