JDBC V2 Connector > JDBC V2 data type reference > JDBC V2 and transformation data types for Create New at Runtime option
  

JDBC V2 and transformation data types for Create New at Runtime option

The following table lists the transformation data types that Data Integration supports and the corresponding Aurora PostgreSQL data types when you use the Create New at Runtime option:
Transformation Data Type
PostgreSQL Data Type
double
float
varbinary
bytea
binary
bytea
tinyint
integer
time
timestamp
smallint
integer
numeric
numeric
real
float
float
float
char
varchar
nchar
varchar
varchar
varchar
nvarchar
varchar
timestamp
timestamp
boolean
varchar
decimal
numeric
bigint
integer
integer
integer
The following table lists the transformation data types that Data Integration supports and the corresponding Azure SQL Database data types when you use the Create New at Runtime option:
Transformation Data Type
Azure SQL Database Data Type
date
datetime2(7)
binary
varbinary
tinyint
int
time
datetime2(7)
smallint
int
numeric
decimal
char
nvarchar
nchar
nvarchar
varchar
nvarchar
nvarchar
nvarchar
real
float
float
float
timestamp
datetime2(7)
boolean
varchar
decimal
decimal
bigint
bigint
integer
int