Mapping java.sql.Types to SQL Types

In GemFire XD, the java.sql.Types are mapped to SQL data types. The following table shows the GemFire XD mapping of types.

java.sql.Types type SQL type
BIGINT BIGINT
BINARY CHAR FOR BIT DATA
BLOB BLOB
CHAR CHAR
CLOB CLOB
DATE DATE
DECIMAL DECIMAL
DOUBLE DOUBLE PRECISION
FLOAT DOUBLE PRECISION(2)
INTEGER INTEGER
LONGVARBINARY LONG VARCHAR FOR BIT DATA
LONGVARCHAR LONG VARCHAR
NULL Not a data type; always a value of a particular type
NUMERIC DECIMAL
REAL REAL
SMALLINT SMALLINT
TIME TIME
TIMESTAMP TIMESTAMP
VARBINARY VARCHAR FOR BIT DATA
VARCHAR VARCHAR