Salesforce-type data types

Table 168. Supported data types
Data Store data type	Intermediary data type	JDBC data type	ODBC data type
ANYTYPE ¹	anytype	VARCHAR	SQL_WVARCHAR or SQL_VARCHAR
AUTONUMBER	string	VARCHAR	SQL_WVARCHAR or SQL_VARCHAR
BINARY	binary	LONGVARBINARY	SQL_LONGVARBINARY
CHECKBOX	boolean	BOOLEAN	SQL_BIT
COMBOBOX	combobox	VARCHAR	SQL_WVARCHAR or SQL_VARCHAR
DATACATEGORYGROUPREFERENCE	DataCategoryGroupReference	VARCHAR	SQL_WVARCHAR or SQL_VARCHAR
EMAIL	email	VARCHAR	SQL_WVARCHAR or SQL_VARCHAR
ENCRYPTEDTEXT	encryptedtext	VARCHAR	SQL_WVARCHAR or SQL_VARCHAR
HTML	html	VARCHAR	SQL_WLONGVARCHAR or SQL_LONGVARCHAR
ID	id	LONGVARCHAR	SQL_WVARCHAR or SQL_VARCHAR
INT	double	INTEGER or DOUBLE ²	SQL_INTEGER or SQL_DOUBLE ³
LONGTEXTAREA	longtextarea	LONGVARCHAR	SQL_WLONGVARCHAR or SQL_LONGVARCHAR
MULTISELECTPICKLIST	multipicklist	VARCHAR	SQL_WVARCHAR or SQL_VARCHAR
NUMBER	double	INTEGER or DOUBLE ⁴	SQL_INTEGER or SQL_DOUBLE ⁵
PHONE	phone	VARCHAR	SQL_WVARCHAR or SQL_VARCHAR
PICKLIST	picklist	VARCHAR	SQL_WVARCHAR or SQL_VARCHAR
REFERENCE	reference	VARCHAR	SQL_WVARCHAR or SQL_VARCHAR
TEXTAREA	textarea	VARCHAR or LONGVARCHAR ⁶	SQL_WVARCHAR, SQL_VARCHAR, SQL_WLONGVARCHAR, or SQL_LONGVARCHAR ⁷
TIME	time	TIME	SQL_TYPE_TIME
URL	url	VARCHAR	SQL_WVARCHAR or SQL_VARCHAR

¹ You cannot create columns with this data type using the Create Table and AlterTable statements.

² If scale = 0 and precision <= 9 and the NumberFieldMapping parameter under the Mapping tab is set to emulateInteger, this data type maps to INTEGER. If scale does not equal 0, precision > 9, orthe NumberFieldMapping parameter under the Mapping tab is set to alwaysDouble, this data type maps to DOUBLE.

³ If scale = 0 and precision <= 9 and the NumberFieldMapping parameter under the Mapping tab is set to emulateInteger, this data type maps to SQL_INTEGER. If scale does not equal 0, precision > 9, or the NumberFieldMapping parameter under the Mapping tab is set to alwaysDouble, this data type maps to SQL_DOUBLE.

⁴ If scale = 0 and precision <= 9 and the NumberFieldMapping parameter under the Mapping tab is set to emulateInteger, this data type maps to INTEGER. If scale does not equal 0, precision > 9, orthe NumberFieldMapping parameter under the Mapping tab is set to alwaysDouble, this data type maps to DOUBLE.

⁵ If scale = 0 and precision <= 9 and the NumberFieldMapping parameter under the Mapping tab is set to emulateInteger, this data type maps to SQL_INTEGER. If scale does not equal 0, precision > 9, or the NumberFieldMapping parameter under the Mapping tab is set to alwaysDouble, this data type maps to SQL_DOUBLE.

⁶ For searchable columns, this data type maps to VARCHAR. For non-searchable columns, it maps to LONGVARCHAR.

⁷ For searchable columns, this data type maps to SQL_WVARCHAR or SQL_VARCHAR. For non-searchable columns, it maps to SQL_WLONGVARCHAR or SQL_LONGVARCHAR.