-
Notifications
You must be signed in to change notification settings - Fork 0
/
salesforce_mapping.txt
23 lines (23 loc) · 1.24 KB
/
salesforce_mapping.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Salesforce Type H2 MySQL Oracle PostgreSQL SQL/Server
ANYTYPE CLOB TEXT NCLOB TEXT NVARCHAR(MAX)
BASE64 CLOB TEXT, MEDIUMTEXT, or LONGTEXT CLOB TEXT VARCHAR(MAX)
BOOLEAN BOOLEAN BOOLEAN DECIMAL(1) BOOLEAN BOOLEAN
COMBOBOX NVARCHAR VARCHAR NVARCHAR2 VARCHAR NVARCHAR
CURRENCY DECIMAL DECIMAL NUMBER NUMERIC DECIMAL
DATACATEGORYGROUPREFERENCE CHAR CHAR CHAR CHAR CHAR
DATE TIMESTAMP DATE TIMESTAMP(3) DATE DATE
DATETIME TIMESTAMP DATETIME TIMESTAMP(3) TIMESTAMP DATETIME
DOUBLE DECIMAL DECIMAL NUMBER NUMERIC DECIMAL
EMAIL NVARCHAR VARCHAR NVARCHAR2 VARCHAR NVARCHAR
ENCRYPTEDSTRING NVARCHAR VARCHAR NVARCHAR2 VARCHAR NVARCHAR
ID CHAR CHAR CHAR CHAR CHAR
INT INTEGER INTEGER, DECIMAL, or BIGINT NUMBER INTEGER INT or BIGINT
MULTIPICKLIST NVARCHAR VARCHAR NVARCHAR2 VARCHAR NVARCHAR
PERCENT DECIMAL DECIMAL NUMBER NUMERIC DECIMAL
PHONE NVARCHAR VARCHAR NVARCHAR2 VARCHAR NVARCHAR
PICKLIST NVARCHAR VARCHAR NVARCHAR2 VARCHAR NVARCHAR
REFERENCE CHAR CHAR CHAR CHAR CHAR
STRING NVARCHAR VARCHAR NVARCHAR2 VARCHAR NVARCHAR
TEXTAREA NVARCHAR VARCHAR NVARCHAR2 VARCHAR NVARCHAR
TIME TIME DATETIME TIMESTAMP(3) TIME DATETIME
URL NVARCHAR VARCHAR NVARCHAR2 VARCHAR NVARCHAR