ServiceNow to MySQL mapping

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

ServiceNow object type MySQL column type
audio VARCHAR
basic image VARCHAR
choice VARCHAR
collection JSON
color VARCHAR
condition string VARCHAR
conditions VARCHAR
currency DECIMAL
data structure VARCHAR
date DATE
date/time DATETIME
decimal DECIMAL
document id VARCHAR
domain id JSON
domain path VARCHAR
due date VARCHAR
duration DECIMAL
encrypted text VARCHAR
field name VARCHAR
file attachment VARCHAR
floating point number FLOAT
fx currency DECIMAL
html VARCHAR
icon VARCHAR
image VARCHAR
integer INT
ip address VARCHAR
journal VARCHAR
journal input VARCHAR
journal list VARCHAR
list VARCHAR
long BIGINT
name-value pairs VARCHAR
password (1 way encrypted) VARCHAR
password (2 way encrypted) VARCHAR
percent complete DECIMAL
phone number (e164) VARCHAR
price DECIMAL
reference JSON
script VARCHAR
script (plain) VARCHAR
slush bucket VARCHAR
string VARCHAR
string (full utf-8) VARCHAR
suggestion VARCHAR
sys id (guid) VARCHAR
table name VARCHAR
template value VARCHAR
time TIME
translated html VARCHAR
translated text VARCHAR
true/false BIT
user roles VARCHAR
url VARCHAR
video VARCHAR
wiki VARCHAR
workflow VARCHAR
sl_timestamp DATETIME