skip to main content
Supported data types : Salesforce-type data types
 

Try DataDirect Cloud Now

Salesforce-type data types

Salesforce-type data stores include Salesforce, FinancialForce, Veeva CRM, and ServiceMax. In communication between your application and the data store, data is mapped several times to the type appropriate for the sending and receiving components. The following table lists the data types used by the data store, the JDBC or ODBC application, and the intermediary types.
Table 19. Supported data types
Data Store data type
Intermediary data type
JDBC data type
ODBC data type
ANYTYPE
You cannot create columns with this data type using the Create Table and AlterTable statements.
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 1
SQL_INTEGER
LONGTEXTAREA
longtextarea
LONGVARCHAR
SQL_WLONGVARCHAR or SQL_LONGVARCHAR
MULTISELECTPICKLIST
multipicklist
VARCHAR
SQL_WVARCHAR or SQL_VARCHAR
NUMBER
double
INTEGER or DOUBLE 2
SQL_INTEGER or SQL_DOUBLE 3
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 4
SQL_WVARCHAR, SQL_VARCHAR, SQL_WLONGVARCHAR, or SQL_LONGVARCHAR 5
TIME
time
TIME
SQL_TYPE_TIME
URL
url
VARCHAR
SQL_WVARCHAR or SQL_VARCHAR

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

2 If scale = 0 and precision <= 9 and the NumberFieldMapping key of the Map Options property is set to emulateInteger, this data type maps to INTEGER. If scale does not equal 0, precision > 9, or the NumberFieldMapping key of the Map Options property is set to alwaysDouble, this data type maps to DOUBLE.

3 If scale = 0 and precision <= 9 and the NumberFieldMapping key of the Map Options property is set to emulateInteger, this data type maps to INTEGER. If scale does not equal 0, precision > 9, or the NumberFieldMapping key of the Map Options property is set to alwaysDouble, this data type maps to DOUBLE.

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

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

* Querying against Salesforce external data sources