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

See "getTypeInfo()" for getTypeInfo() results of data types supported by the driver.

Table 1. Microsoft SharePoint Data Types
Microsoft SharePoint Data Type JDBC Data Type
BINARY VARBINARY
BOOLEAN BOOLEAN
BYTE SMALLINT
DATE DATE
DATETIMEOFFSET TIMESTAMP
DECIMAL DECIMAL
DOUBLE DOUBLE
ENUM VARCHAR
GUID CHAR
INT16 SMALLINT
INT32 INTEGER
INT64 BIGINT
SBYTE TINYINT
SINGLE REAL
STRING VARCHAR
TIMEOFDAY TIME