Data Types

Table 21-2 lists the data types supported by the Salesforce driver for local tables, how the Salesforce data types exposed by the Salesforce Web Service API map to them, and how the Salesforce Web Service API data types map to the ODBC data types.

 

Table 21-2. Salesforce Data Types for Local Tables  

Salesforce Data Type	Web Service API Data Type	ODBC Data Type
ANYTYPE	anytype	SQL_WVARCHAR
AUTONUMBER	string	SQL_WVARCHAR
BINARY	binary	SQL_LONGVARBINARY
CHECKBOX	boolean	SQL_BIT
COMBOBOX	combobox	SQL_WVARCHAR
CURRENCY	currency	SQL_DOUBLE
DATE	date	SQL_TYPE_DATE
DATETIME	datetime	SQL_TYPE_TIMESTAMP
EMAIL	email	SQL_WVARCHAR
ENCRYPTEDTEXT	encryptedtext	SQL_WVARCHAR
HTML	html	SQL_WLONGVARCHAR
ID	id	SQL_WVARCHAR
INT	double	SQL_INTEGER
LONGTEXTAREA	longtextarea	SQL_WLONGVARCHAR
MULTISELECTPICKLIST	multipicklist	SQL_WVARCHAR
NUMBER	double	SQL_DOUBLE if scale does not = 0 or precision > 9 or the NumberFieldMapping key of the ConfigOptions connection option is set to 2. SQL_INTEGER if scale = 0 and precision <= 9 and the NumberFieldMapping key of the ConfigOptions connection option is set to 1.
PERCENT	percent	SQL_DOUBLE
PHONE	phone	SQL_WVARCHAR
PICKLIST	picklist	SQL_WVARCHAR
REFERENCE	reference	SQL_WVARCHAR
TEXT	string	SQL_WVARCHAR
TEXTAREA	textarea	SQL_WVARCHAR
TIME	time	SQL_TYPE_TIME
URL	url	SQL_WVARCHAR

Table 21-3 lists the data types supported by the Salesforce driver for remote tables, how the Salesforce data types exposed by the Salesforce Web Service API map to them, and how the Salesforce Web Service API data types map to the ODBC data types.

 

Table 21-3. Salesforce Data Types for Remote Tables  

Salesforce Data Type	Web Service API Data Type	ODBC Data Type
ANYTYPE	anytype	SQL_WVARCHAR
AUTONUMBER	string	SQL_WVARCHAR
BINARY	binary	SQL_LONGVARBINARY
CHECKBOX	boolean	SQL_BIT
COMBOBOX	combobox	SQL_WVARCHAR
CURRENCY	currency	SQL_DOUBLE
DATACATEGORYGROUPREFERENCE	DataCategoryGroupReference	SQL_WVARCHAR
DATE	date	SQL_TYPE_DATE
DATETIME	datetime	SQL_TYPE_TIMESTAMP
EMAIL	email	SQL_WVARCHAR
HTML	html	SQL_WLONGVARCHAR
ID	id	SQL_WVARCHAR
INT	double	SQL_INTEGER
LONGTEXTAREA	longtextarea	SQL_WLONGVARCHAR
MULTISELECTPICKLIST	multipicklist	SQL_WVARCHAR
NUMBER	double	SQL_DOUBLE if scale does not = 0 or precision > 9 or the NumberFieldMapping key of the ConfigOptions connection option is set to 2. SQL_INTEGER if scale = 0 and precision <= 9 and the NumberFieldMapping key of the ConfigOptions connection option is set to 1.
PERCENT	percent	SQL_DOUBLE
PHONE	phone	SQL_WVARCHAR
PICKLIST	picklist	SQL_WVARCHAR
REFERENCE	reference	SQL_WVARCHAR
TEXT	string	SQL_WVARCHAR
TEXTAREA	textarea	SQL_WVARCHAR
TIME	time	SQL_TYPE_TIME
URL	url	SQL_WVARCHAR