Db2 for LUW Source Data Type | Amazon Redshift Target Data Type |
|---|---|
bigint | bigint |
binary(size), 1 <= size <= 255 | binary varying(size), 1 <= size <= 255 |
boolean | boolean |
char for bit data | binary varying(1) |
char(size) for bit data, 2 <= size <= 255 | binary varying(size), 2 <= size <= 255 |
character(size), 1 <= s <= 255 | character(size), 4 <= size <= 1020 |
date | date |
decfloat(precision), 16 <= p <= 34 | character varying(255) |
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31 | numeric(p,s), 1 <= p <= 31, 0 <= s <= 31 |
double | double precision |
integer | integer |
long varchar | character varying(65535) |
long varchar for bit data | binary varying(32700) |
real | real |
smallint | smallint |
time | time without time zone |
timestamp(precision), 0 <= p <= 6 | timestamp without time zone |
timestamp(precision), 7 <= p <= 12 | character varying(size), 27 <= size <= 32 |
varbinary(size), 1 <= size <= 32672 | binary varying(size), 1 <= size <= 32672 |
varchar(size) for bit data, 1 <= size <= 32672 | binary varying(size), 1 <= size <= 32672 |
varchar(size), 1 <= size <= 32672 | character varying(size), 4 <= size <= 65535 |