The following table lists the data types supported by the Salesforce driver, the Salesforce data types exposed by the Salesforce Web Service API that map to the data types, and the JDBC data types that map to the 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 DOUBLE
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 DOUBLE
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.