Data Types
This is supported by JDBC Java DataBase Connectivity. This is an application programming interface (API) for the Java programming language, which defines how a client may access a database. V3
Supported Data Types and Type Conversions
The following table lists all of the supported data types, and the conversions allowed for each data type.
Convert From | Convert To | |
BOOLEAN |
VARCHAR, BOOLEAN, OBJECT |
java.lang.Boolean |
VARCHAR (STRING) |
All types |
java.lang.String |
TINYINT |
VARCHAR, BOOLEAN, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Byte |
SMALLINT |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Short |
INTEGER |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Integer |
BIGINT |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Long |
DECIMAL |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.math.BigDecimal |
REAL |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Float |
DOUBLE |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Double |
DATE |
VARCHAR, DATE, TIME, TIMESTAMP, TIMESTAMP WITH TIME ZONE, OBJECT |
java.time.LocalDate |
TIME |
VARCHAR, DATE, TIME, TIMESTAMP, TIMESTAMP WITH TIME ZONE, OBJECT |
java.time.LocalTime |
TIMESTAMP |
VARCHAR, DATE, TIME, TIMESTAMP, TIMESTAMP WITH TIME ZONE, OBJECT |
java.time.LocalDateTime |
OBJECT |
All types |
Any Java class |