MySQL Type

DTS Type

bigint

INT64

int

INT32

integer

INT32

mediumint

INT32

smallint

INT16

tinyint

UNSIGNED_INT8

numeric

DECIMAL

decimal

DECIMAL

dec

DECIMAL

fixed

DECIMAL

bit

BOOLEAN

float

FLOAT

real

FLOAT

double

DOUBLE

double precision

DOUBLE

date

DATE

year

DATE

datetime

DATE_TIME

timestamp

DATE_TIME

time

TIME

char

STRING

varchar

STRING

enum

STRING

set

STRING

binary

BINARY

varbinary

BINARY

geometry

DTS_GEOMETRY

point

DTS_POINT_GEOMETRY

linestring

DTS_LINE_GEOMETRY

polygon

DTS_AREA_GEOMETRY

multipoint

DTS_MULTIPOINT_GEOMETRY

multilinestring

DTS_MULTILINE_GEOMETRY

multipolygon

DTS_MULTIAREA_GEOMETRY

geometrycollection

DTS_GEOMETRY