The following table lists the data types supported by the driver, how the Salesforce data types are exposed in the Salesforce Web Service API, and how these data types are mapped to JDBC data types.

Table 1. Salesforce Data Types
Salesforce Data Type Web Service API Data Type JDBC Data Type
ANYTYPE 1 anytype VARCHAR
AUTONUMBER string VARCHAR
BINARY 2 binary LONGVARBINARY
CHECKBOX boolean BOOLEAN
COMBOBOX 3 combobox VARCHAR
CURRENCY Formula (CURRENCY) currency DECIMAL
DATACATEGORYGROUPREFERENCE DataCategoryGroupReference VARCHAR
DATE Formula (DATE) date DATE
DATETIME Formula (DATETIME) datetime DATETIME
EMAIL email VARCHAR
ENCRYPTEDTEXT encryptedtext VARCHAR
HTML html VARCHAR
ID id LONGVARCHAR
INT 4 double INTEGER or DOUBLE
LONGTEXTAREA longtextarea LONGVARCHAR
MULTISELECTPICKLIST multipicklist VARCHAR
NUMBER 5 double INTEGER or DOUBLE
PERCENT Formula (PERCENT) percent DECIMAL
PHONE phone VARCHAR
PICKLIST picklist VARCHAR
REFERENCE reference VARCHAR
TEXT Formula (TEXT) string VARCHAR
TEXTAREA 6 textarea VARCHAR or LONGVARCHAR
TIME 7 time TIME
URL url VARCHAR
1 You cannot create columns with this data type using the Create Table and AlterTable statements.
2 You cannot create columns with this data type using the Create Table and AlterTable statements.
3 You cannot create columns with this data type using the Create Table and AlterTable statements.
4 If the NumberFieldMapping key of the ConfigOptions property is set to emulateInteger, this data type maps to INTEGER. If set to alwaysDouble, this data type maps to DOUBLE.
5 If scale = 0 and precision <= 9 and the NumberFieldMapping key of the ConfigOptions property is set to emulateInteger, this data type maps to INTEGER. If scale does not = 0, precision > 9, or the NumberFieldMapping key of the ConfigOptions property is set to alwaysDouble, this data type maps to DOUBLE.
6 For searchable columns, this data type maps to VARCHAR. For non-searchable columns, it maps to LONGVARCHAR.
7 You cannot create columns with this data type using the Create Table and AlterTable statements.