MySQL Source Data Type | Amazon Redshift Target Data Type |
|---|---|
bigint | bigint |
bigint unsigned | numeric(20,0) |
binary(size), 1 <= size <= 255 | binary varying(size), 1 <= size <= 255 |
bit | binary varying(2) |
bit(precision), 1 <= p <= 64 | binary varying(size), 1 <= size <= 8 |
blob | binary varying |
char(size), 1 <= size <= 255 | character varying(size), 3 <= size <= 765 |
date | date |
datetime | timestamp without time zone |
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29 | numeric(p,s), 1 <= p <= 38, 0 <= s <= 29 |
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29 | character varying(size), 40 <= size <= 67 |
double | double precision |
float | real |
geomcollection | binary varying(1024000) |
geometry | binary varying(1024000) |
geometrycollection | binary varying(1024000) |
int | integer |
int unsigned | bigint |
json | super |
linestring | binary varying(1024000) |
longblob | binary varying |
longtext | character varying |
mediumblob | binary varying |
mediumint | integer |
mediumint unsigned | integer |
mediumtext | character varying |
multilinestring | binary varying(1024000) |
multipoint | binary varying(1024000) |
multipolygon | binary varying(1024000) |
numeric | numeric(10,0) |
point | binary varying(1024000) |
polygon | binary varying(1024000) |
smallint | smallint |
smallint unsigned | integer |
text | character varying |
time(precision), 0 <= p <= 6 | character varying(size), 10 <= size <= 17 |
timestamp(precision), 0 <= p <= 6 | timestamp without time zone |
tinyblob | binary varying |
tinyint | smallint |
tinyint unsigned | smallint |
tinytext | character varying |
varbinary(size), 1 <= size <= 65535 | binary varying(size), 1 <= size <= 65535 |
varchar(size), 1 <= size <= 21844 | character varying(size), 3 <= size <= 65532 |
year | smallint |