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 |