Data Types

Table 1. Salesforce Data Types
Salesforce Data Type	Web Service API Data Type	JDBC Data Type
ANYTYPE ¹	anytype	VARCHAR
AUTONUMBER	string	VARCHAR
BINARY ²	binary	LONGVARBINARY
CHECKBOX	boolean	BOOLEAN
COMBOBOX ³	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 ⁴	double	INTEGER or DOUBLE
LONGTEXTAREA	longtextarea	LONGVARCHAR
MULTISELECTPICKLIST	multipicklist	VARCHAR
NUMBER ⁵	double	INTEGER or DOUBLE
PERCENT Formula (PERCENT)	percent	DECIMAL
PHONE	phone	VARCHAR
PICKLIST	picklist	VARCHAR
REFERENCE	reference	VARCHAR
TEXT Formula (TEXT)	string	VARCHAR
TEXTAREA ⁶	textarea	VARCHAR or LONGVARCHAR
TIME ⁷	time	TIME
URL	url	VARCHAR

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

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

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

⁴ 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.

⁵ 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.

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

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