skip to main content
DataDirect Connect XE Drivers : Salesforce Driver : Data Types
  
Data Types
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 88. 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.