Data Types
The Simba Salesforce JDBC Connector supports many common data formats, converting between Salesforce, SQL, and Java data types.
The following table lists the supported data type mappings.
| Salesforce Type | SQL Type | Java Type |
|---|---|---|
|
AnyType |
VARCHAR |
String |
|
Auto Number |
VARCHAR |
String |
|
base64 |
VARBINARY |
byte[] |
|
Checkbox |
BIT |
Boolean |
|
Combobox |
VARCHAR |
String |
|
Currency |
DOUBLE |
Double |
|
Date |
DATE |
java.sql.Date |
|
DateCategoryGroupReference |
VARCHAR |
String |
|
Date/Time |
TIMESTAMP |
java.sql.Timestamp |
|
|
VARCHAR |
String |
|
Id |
VARCHAR |
String |
|
Lookup Relationship |
VARCHAR |
String |
|
Multi-Select Picklist |
VARCHAR |
String |
|
Percent |
DOUBLE |
Double |
|
Phone |
VARCHAR |
String |
|
Picklist |
VARCHAR |
String |
|
Reference |
VARCHAR |
String |
|
Text |
VARCHAR |
String |
|
Text Area |
VARCHAR |
String |
|
Text Area (Long) |
VARCHAR |
String |
|
Text Area (Rich) |
VARCHAR |
String |
|
Text (Encrypted) |
VARCHAR |
String |
|
Time |
TIME |
java.sql.Time |
|
URL |
VARCHAR |
String |