Db2 for LUW Source Data Type | Microsoft Azure Synapse Analytics Target Data Type |
|---|---|
bigint | bigint |
binary(size), 1 <= size <= 255 | binary(size), 1 <= size <= 255 |
blob | varbinary(max) |
boolean | bit |
char for bit data | binary |
char(size) for bit data, 2 <= size <= 255 | binary(size), 2 <= size <= 255 |
char(size), 1 <= size <= 255 | char(size), 1 <= size <= 255 |
clob | varchar(max) |
date | date |
dbclob | varchar(max) |
decfloat(precision), 16 <= p <= 34 | varchar(255) |
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31 | decimal(p,s), 1 <= p <= 31, 0 <= s <= 31 |
double | float |
integer | int |
long varchar | varchar(max) |
long varchar for bit data | varbinary(max) |
long vargraphic | varchar(max) |
real | real |
smallint | smallint |
time | time(0) |
timestamp(precision), 0 <= p <= 7 | datetime2(precision), 0 <= p <= 7 |
timestamp(precision), 8 <= p <= 12 | char(size), 28 <= size <= 32 |
varbinary(size), 1 <= size <= 32672 | varbinary(size), 1 <= size <= max |
varchar(size) for bit data, 1 <= size <= 32672 | varbinary(size), 1 <= size <= max |
varchar(size), 1 <= size <= 32672 | varchar(size), 1 <= size <= max |
xml | varchar(max) |