Salesforce to MySQL mapping

AutoSync maps Salesforce object types to the following MySQL column types:


Salesforce object type	MySQL column type
`base64`	`VARCHAR`
`boolean`	`BIT`
`byte`	`BIGINT`
`date`	`DATE`
`datetime`	`DATETIME`
`decimal`	`DECIMAL`
`double`	`DECIMAL`
`int`	`INT`
`long`	`BIGINT`
`string`	`VARCHAR`
`time`	`TIME`
`sl_timestamp`	`DATETIME`
`address`	`JSON`
`anyType`	`VARCHAR`
`calculated`	`VARCHAR`
`combobox`	`VARCHAR`
`currency`	`DECIMAL`
`datacategorygroupreference`	`VARCHAR`
`email`	`VARCHAR`
`encryptedstring`	`VARCHAR`
`id`	`VARCHAR`
`junctionidlist`	`VARCHAR`
`location`	`VARCHAR`
`masterrecord`	`VARCHAR`
`multipicklist`	`VARCHAR`
`percent`	`DECIMAL`
`phone`	`VARCHAR`
`picklist`	`VARCHAR`
`reference`	`VARCHAR`
`textarea`	`VARCHAR`
`url`	`VARCHAR`
`complexvalue`	`VARCHAR`
`json`	`JSON`