Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

JDBC Client

  • Last Updated: May 12, 2026
  • 1 minute read
    • OpenAccess SDK
    • Version 8.1
    • Documentation

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

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
TitleResults for “How to create a CRG?”Also Available inAlert