Data Types Supported : Supported Data Types : JDBC Client

JDBC Client

The following table lists the data types that the JDBC Client supports for the OpenAccess SDK SQL engine or a third-party SQL engine:

Table 43: Mapping OpenAccess SDK Data Types to JDBC Data Types
OpenAccess Data Type	JDBC Data Type
BIGINT	BIGINT
BINARY	BINARY
BIT	BIT
CHAR	CHAR
DATE	DATE
DOUBLE	DOUBLE
FLOAT	FLOAT
INTEGER	INTEGER
LONGVARBINARY	LONGVARBINARY
LONGVARCHAR	LONGVARCHAR
NUMERIC	NUMERIC
REAL	REAL
SMALLINT	SMALLINT
TIME	TIME
TIMESTAMP	TIMESTAMP
TINYINT	TINYINT
VARBINARY	VARBINARY
VARCHAR	VARCHAR
WCHAR	CHAR
WLONGVARCHAR	LONGVARCHAR
WVARCHAR	VARCHAR