Contents

HVR's mapping/conversion of data types is complex because each DBMS's data types have a specific range which seldom corresponds the range of another DBMS. For example, data type varchar(10) in SQL Server corresponds to varchar2(10 bytes) in Oracle, but varchar(8000) corresponds to clob. Note that the mapping here does not just depend on the 'name' of the data type, but also its 'attributes' like byte length, encoding, scale and precision, etc. If HVR is not accurate in mapping data types, then target tables could be created which are unable to contain the data delivered from the source DBMS.

Data types are not directly mapped/converted from the source DBMS to the target DBMS, instead they are first mapped to HVR's own 'catalog data types' and then these catalog data types are mapped to corresponding data types in target DBMS or file format. Data type mapping/conversion happens in the following manner:

When a channel is built using Table Explore or using the command Hvradapt, the source DBMS data types mapped to HVR's own 'catalog data types'.
After the tables are added to a channel the mapping of data types in source DBMS (capture location) to HVR's catalog data types can be viewed in HVRGUI from the Table Explore window.
Then during HVR Refresh and Integrate, HVR's catalog data types are mapped to corresponding data types in the target DBMS (integrate location). This mapping happens at the moment the HVR Refresh is used to create target tables.
After performing HVR Refresh/Integrate the mapping of HVR's catalog data types to the target DBMS data types can be viewed in HVRGUI from the Table Explore window.

Customizing Data Type Mapping

If the automatic/default mapping of data type is not appropriate for a specific channel, it can be modified using action ColumnProperties /Datatype.

For example, by default HVR maps a number (without scale or precision) in Oracle to numeric(38,4) in SQL Server. By defining the following action, number (without scale or precision) in Oracle is mapped to float instead:

Group	Table	Action
SRCGRP	*	ColumnProperties /DatatypeMatch="number[prec=0 && scale=0]" /Datatype="float"

In the above example, ColumnProperties /DatatypeMatch is used for mapping all columns with number (without scale or precision) data type into float data type.

Alternatively, ColumnProperties /Name can be used for mapping the data type of a specific column (e.g. MYCOLUMN) into float data type.

Group	Table	Action
SRCGRP	*	ColumnProperties /Name="MYCOLUMN" /Datatype="float"

Extended Data Type Support

'Extended data types' are the DBMS data types (e.g. sql_variant in SQL Server or xmltype in Oracle) which are not mapped to native HVR data types. Instead, HVR's Extended Data Type Support feature should be used for such data types.

HVR uses action ColumnProperties /CaptureExpression for converting an extended data type to a supported data type during capture, compare or refresh (source) and ColumnProperties /IntegrateExpression for converting it back to extended data type during integrate, compare or refresh (target) respectively.

Data Type Mapping - Source to Target DBMS

In this section, you can find the mapping of data types in source DBMS to the corresponding data types in target DBMS or file format.

Select the required source DBMS in Source Location Class; displays the mapping of source DBMS data type to HVR catalog data type.
Select the required target DBMS in Target Location Class; displays the mapping of HVR catalog data type to target DBMS data type.

For example, to illustrate the data type mapping of timestamp with time zone in Oracle to the corresponding data type in Avro:

Select Oracle in Source Location Class.
In the table displayed below Source Location Class, you can find that timestamp with time zone (in column HVR Catalog Data Type) is mapped to HVR's catalog data type timestamp with tz (oracle) (in column HVR Catalog Data Type).
Select Avro 1.6 and Avro 1.8 in Target Location Class.
In the table displayed below Target Location Class, you can find that timestamp with tz (oracle) (in column HVR Catalog Data Type) is mapped to varchar(100) in Avro 1.6 and timestamp-millis in Avro 1.8.

Data Type	HVR Capture Support	HVR Catalog Data Type
bigint	Native	bigint
decfloat	Native	decfloat
decimal	Native	decimal
double	Native	double
integer	Native	integer
numeric	Native	numeric (db2i)
real	Native	real
smallint	Native	smallint
date	Native	ansidate
time	Native	time2
timestamp	Native	timestamp
char	Native	char
clob	Native	clob
varchar	Native	varchar
binary	Native	binary
blob	Native	blob
varbinary	Native	varbinary
datalink	Extended	<<datalink>>
xml	Extended	<<xml>>
rowid	Extended	<<rowid>>
dbclob	Native	clob
graphic	Native	nchar
vargraphic	Native	nvarchar
user defined	Extended	<<user defined>>

Data Type	HVR Capture Support	HVR Catalog Data Type
bigint	Native	bigint
decfloat	Native	decfloat
decimal	Native	decimal
double	Native	double
float	Native	double
integer	Native	integer
numeric	Native	decimal
real	Native	real
smallint	Native	smallint
date	Native	ansidate
time	Native	time
timestamp	Native	timestamp
char	Native	char
char for bit data	Native	binary
clob	Native	clob
long varchar	Native	long varchar (db2)
long varchar for bit data	Native	long varbinary
varchar	Native	varchar
varchar for bit data	Native	varbinary
binary	Native	binary
blob	Native	blob
varbinary	Native	varbinary
dbclob	Native	dbclob
graphic	Native	graphic
long vargraphic	Native	long nvarchar (db2)
nclob	Native	dbclob
vargraphic	Native	vargraphic
xml	Native¹	db2 xml¹
rowid	Not supported
user defined	Not supported
¹ - Since HVR 5.6.5/2, the 'xml' data type is supported as 'Native' and is mapped to the HVR Catalog Type 'db2 xml'. Action Capture /AugmentIncomplete=LOB is required to capture xml type from DB2 for Linux, UNIX and Windows.

Data Type	HVR Capture Support	HVR Catalog Data Type
smallint	Native	smallint
integer	Native	integer
bigint	Native	bigint
decimal	Native	decimal
decfloat	Native	decfloat
real	Native	real
double	Native	double
date	Native	ansidate
time	Native	time2
timstamp without time zone	Native	timestamp
timestamp with time zone	Native	db2 timestamp with time zone
char	Native	char
varchar	Native	varchar
clob	Native	clob
binary	Native	binary
blob	Native	blob
varbinary	Native	varbinary
dbclob	Native	nclob
graphic	Native	nchar
vargraphic	Native	nvarchar
xml	Native	db2 xml¹
rowid	Not Supported
¹ - Since HVR 5.6.5/2, the 'xml' data type is mapped to the HVR Catalog Type 'db2 xml'.

Data Type	HVR Capture Support	HVR Catalog Data Type
bigint	Native	bigint
decfloat	Extended	<<decfloat>>
decimal	Native	decimal
double	Native	double
integer	Native	integer
numeric	Native	numeric (db2i)
real	Native	real
smallint	Native	smallint
date	Native	ansidate
time	Native	time2
timestamp	Native	timestamp
char	Native	char
clob	Native	clob
varchar	Native	varchar
binary	Native	binary
blob	Native	blob
varbinary	Native	varbinary
datalink	Extended	<<datalink>>
xml	Extended	<<xml>>
rowid	Extended	<<rowid>>
dbclob	Native	clob
graphic	Native	nchar
vargraphic	Native	nvarchar
user defined	Extended	<<user defined>>

Data Type	HVR Capture Support	HVR Catalog Data Type
bigint	Native	integer8
decimal	Native	decimal
float	Native	float8
float4	Native	float4
float8	Native	float8
integer	Native	integer4
integer1	Native	integer1
integer2	Native	integer2
integer4	Native	integer4
integer8	Native	integer8
real	Native	float4
smallint	Native	integer2
tinyint	Native	integer1
ansidate	Native	ansidate
ingresdate	Native	ingresdate
interval day to second	Native	interval day to second (ingres)
interval year to month	Native	interval year to month (ingres)
time with local time zone	Native	time with local time zone
time with time zone	Native	time with time zone
time without time zone	Native	time
timestamp with local timezone	Native	timestamp with local timezone
timestamp with time zone	Native	timestamp with time zone
timestamp without time zone	Native	timestamp (ingres)
c	Native	c
char	Native	char
clob	Native	long varchar
long nvarchar	Native	long nvarchar
long varchar	Native	long varchar
nchar	Native	nchar
nclob	Native	long nvarchar
nvarchar	Native	nvarchar
text	Native	text (ingres)
varchar	Native	varchar
ipv4	Extended	<<ipv4>>
ipv6	Extended	<<ipv6>>
logical_key	Extended	<<logical_key>>
money	Native	money (ingres)
uuid	Extended	<<uuid>>
byte	Native	byte
byte varying / varbyte	Native	byte varying
long byte	Native	long byte
boolean	Native	boolean
circularstring	Extended	<<circularstring>>
compoundcurve	Extended	<<compoundcurve>>
curvepolygon	Extended	<<curvepolygon>>
geometry	Extended	<<geometry>>
geometrycollection	Extended	<<geometrycollection>>
linestring	Extended	<<linestring>>
multicurve	Extended	<<multicurve>>
multilinestring	Extended	<<multilinestring>>
multipoint	Extended	<<multipoint>>
multipolygon	Extended	<<multipolygon>>
multisurface	Extended	<<multisurface>>
point	Extended	<<point>>
polygon	Extended	<<polygon>>
polyhedralsurface	Extended	<<polyhedralsurface>>
tin	Extended	<<tin>>
triangle	Extended	<<triangle>>

Data Type	HVR Capture Support	HVR Catalog Data Type
bigint	Native	bigint
bigint unsigned	Native	bigint unsigned
bit	Native	bit (mysql)
bool	Native	tinyint signed
boolean	Native	tinyint signed
dec	Native	decimal
decimal	Native	decimal
decimal unsigned	Native	decimal
double	Native	double
double precision	Native	double
double unsigned	Native	double
fixed	Native	decimal
float	Native	real
float unsigned	Native	real
int	Native	int
int unsigned	Native	int unsigned
integer	Native	int
mediumint	Native	mediumint
mediumint unsigned	Native	mediumint unsigned
numeric	Native	decimal
real	Native	double
smallint	Native	smallint
smallint unsigned	Native	smallint unsigned
tinyint	Native	tinyint signed
date	Native	ansidate
datetime	Native	datetime (mysql)
time	Native	time (mysql)
timestamp	Native	timestamp (mysql)
year	Native	smallint
binary	Native	binary
blob	Native	varbinary(max)
char	Native	char
char byte	Native	binary
json	Native	varchar(max)
longblob	Native	varbinary(max)
longtext	Native	varchar(max)
mediumblob	Native	varbinary(max)
mediumtext	Native	varchar(max)
text	Native	varchar(max)
tinyblob	Native	varbinary(max)
tinytext	Native	varchar(max)
varbinary	Native	varbinary
varchar	Native	varchar
geometry	Extended	<<geometry>>
geometrycollection	Extended	<<geometrycollection>>
linestring	Extended	<<linestring>>
multilinestring	Extended	<<multilinestring>>
multipoint	Extended	<<multipoint>>
multipolygon	Extended	<<multipolygon>>
point	Extended	<<point>>
polygon	Extended	<<polygon>>

Data Type	HVR Capture Support	HVR Catalog Data Type
bigint	Native	bigint
bigint unsigned	Native	bigint unsigned
bit	Native	bit (mysql)
bool	Native	tinyint signed
boolean	Native	tinyint signed
dec	Native	decimal
dec unsigned	Native	decimal
decimal	Native	decimal
decimal unsigned	Native	decimal
double	Native	double
double precision	Native	double
double precision unsigned	Native	double
double unsigned	Native	double
fixed	Native	decimal
fixed unsigned	Native	decimal
float	Native	real
float unsigned	Native	real
int	Native	int
int unsigned	Native	int unsigned
integer	Native	int
integer unsigned	Native	int unsigned
mediumint	Native	mediumint
mediumint unsigned	Native	mediumint unsigned
numeric	Native	decimal
numeric unsigned	Native	decimal
real	Native	double
real unsigned	Native	double
smallint	Native	smallint
smallint unsigned	Native	smallint unsigned
tinyint	Native	tinyint signed
tinyint unsigned	Native	tinyint unsigned
date	Native	ansidate
datetime	Native	datetime (mysql)
time	Native	time (mysql)
timestamp	Native	timestamp (mysql)
year	Native	smallint
binary	Native	binary
blob	Native	varbinary(max)
char	Native	char
long varchar	Native	varchar(max)
longblob	Native	varbinary(max)
longtext	Native	varchar(max)
mediumblob	Native	varbinary(max)
mediumtext	Native	varchar(max)
long	Native	varchar(max)
text	Native	varchar(max)
tinyblob	Native	varbinary(max)
tinytext	Native	varchar(max)
varbinary	Native	varbinary
varchar	Native	varchar
enum	Extended	<<enum>>
set	Extended	<<set>>
geometry	Extended	<<geometry>>
geometrycollection	Extended	<<geometrycollection>>
linestring	Extended	<<linestring>>
multilinestring	Extended	<<multilinestring>>
multipoint	Extended	<<multipoint>>
multipolygon	Extended	<<multipolygon>>
point	Extended	<<point>>
polygon	Extended	<<polygon>>
json	Extended	<<json>>

Data Type	HVR Capture Support	HVR Catalog Data Type
binary_double	Native	binary_double
binary_float	Native	binary_float
float	Native	number
long	Native	long
number	Native	number
date	Native	date
interval day to second	Native	interval day to second
interval year to month	Native	interval year to month
timestamp	Native	timestamp (oracle)
timestamp with local time zone	Native	timestamp with local tz (oracle)
timestamp with time zone	Native	timestamp with tz (oracle)
char	Native	char (oracle)
nchar	Native	nchar (oracle)
nvarchar2	Native	nvarchar2
varchar	Native	varchar2
varchar2	Native	varchar2
long raw	Native	long raw
raw	Native	raw
bfile	Native	bfile
blob	Native	blob
clob	Native	clob
nclob	Native	nclob
rowid	Native	rowid
urowid	Native	urowid
extended data types	Extended	<<data type>>
ref	Extended	<<data type>>
varrays	Extended	<<data type>>
nested tables	Extended	<<data type>>
anytype	Extended	<<data type>>
anydata	Extended	<<data type>>
anydataset	Extended	<<data type>>
uri	Extended	<<data type>>
xmltype	Extended	<<xmltype>>
sdo_geometry	Extended	<<data type>>
sdo_georaster	Extended	<<data type>>
sdo_topo_geometry	Extended	<<data type>>
media	Extended	<<data type>>

Data Type	HVR Capture Support	HVR Catalog Data Type
smallint	Native	smallint
integer	Native	integer
int	Native	integer
bigint	Native	bigint
int2	Native	smallint
int4	Native	integer
int8	Native	bigint
decimal	Native	number
numeric	Native	number
double precision	Native	float
real	Native	real
smallserial	Native	smallint
serial2	Native	smallint
serial	Native	integer
bigserial	Native	bigint
serial8	Native	bigint
time	Native	time
time with time zone	Native	time with time zone
timestamp	Native	postgres timestamp
timestamp with time zone	Native	postgres timestamp with time zone
date	Native	postgres date
interval	Extended	<<interval>>
char / character	Native	char
varchar	Native	varchar or clob (if char length is large)
text	Native	clob
bytea	Native	blob
json	Native	json
jsonb	Native	jsonb
boolean	Native	boolean
money	Extended	<<money>>
point	Extended	<<point>>
line	Extended	<<line>>
lseg	Extended	<<_lseg>>
box	Extended	<<_box>>
path	Extended	<<path>>
polygon	Extended	<<polygon>>
circle	Extended	<<circle>>
cidr	Extended	<<cidr>>
inet	Extended	<<inet>>
macaddr	Extended	<<macaddr>>
macaddr8	Extended	<<macaddr8>>
bit	Extended	<<bit>>
bit varying / varbit	Extended	<<varbit>>
tsvector	Extended	<<tsvector>>
tsquery	Extended	<<tsquery>>
uuid	Extended	<<uuid>>
xml	Extended	<<xml>>
int4range	Extended	<<int4range>>
int8range	Extended	<<int8range>>
numrange	Extended	<<numrange>>
tsrange	Extended	<<tsrange>>
tstzrange	Extended	<<tstzrange>>
daterange	Extended	<<daterange>>
oid	Extended	<<oid>>
pg_lsn	Extended	<<pg_lsn
domain	Extended	<<domain>>
user defined	Extended	<<user defined>>

Data Type	HVR Capture Support	HVR Catalog Data Type
int	Native	int
bigint	Native	bigint
smallint	Native	smallint
tinyint	Native	tinyint
numeric	Native	numeric
decimal	Native	numeric
bit	Native	bit
money	Native	money
smallmoney	Native	smallmoney
float	Native	float
real	Native	real
date	Native	ansidate
datetime	Native	datetime
datetime2	Native	datetime(2)
datetimeoffset	Native	datetimeoffset
smalldatetime	Native	smalldatetime
time	Native	time
char	Native	char
varchar	Native	varchar
text	Native	text (sqlserver)
nchar	Native	nchar
nvarchar	Native	nvarchar
ntext	Native	ntext
binary	Native	binary
varbinary	Native	varbinary
image	Native	image
uniqueidentifier	Native	uniqueidentifier
xml	Native	xml
cursor	Extended	<<cursor>>
hierarchyid	Extended	<<hierarchyid>>
rowversion	Extended	<<rowversion>>
sql_variant	Extended	<<sql_variant>>
spatial geometry types	Extended	<<geometry>>
spatial geography types	Extended	<<geography>>
table	Extended	<<table>>

HVR Catalog Data Types	Attributes	Aurora MySQL (UTF-8)	Aurora PostgreSQL (UTF-8)	Avro 1.6	Avro 1.8	Azure SQL Data Warehouse	Azure SQL Database	DB2 for Linux, UNIX and Windows (UTF-8)	DB2 for i	DB2 for z/OS	Greenplum (UTF-8)	HANA	Hive ACID	Hive external table backed by Avro 1.8	Hive external table backed by CSV	Hive external table backed by Json	Hive external table backed by Parquet	Ingres (UTF-8)	MariaDB (UTF-8)	MySQL (UTF-8)	Oracle (AL32UTF8)	Oracle (CESU-8)	Oracle (Windows-1252)	Parquet	PostgreSQL (UTF-8)	Redshift	SQL Server (Windows-1252)	Snowflake	Teradata	Vector
ansidate (ingres)		date	date	bigint	date	date	date	date	date	date	date	date	date	date	date	date	date	ansidate	date	date	date	date	date	date	date	date	date	date	date	ansidate
ansidate		date	date	bigint	date	date	date	date	date	date	date	date	date	date	date	date	date	ansidate	date	date	date	date	date	date	date	date	date	date	date	ansidate
bfile		longblob	bytea	blob	blob	varbinary(max)	varbinary(max)	blob(2147483647)	blob(2147483647)	blob(2147483647)	bytea	blob	binary	binary	binary	string	binary	long byte	longblob	longblob	bfile	bfile	bfile	blob	bytea	varchar(65535)	varbinary(max)	binary(8388608)	blob(2097088000)	varchar(32000)
bigint unsigned	bytelen=8	bigint unsigned	numeric(20)	float	decimal(20)	numeric(20)	numeric(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	bigint unsigned	bigint unsigned	number(20)	number(20)	number(20)	decimal(20)	numeric(20)	decimal(20)	numeric(20)	number(38)	decimal(20)	decimal(20)
bigint	bytelen=8	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	number(19)	number(19)	number(19)	bigint	bigint	bigint	bigint	number(38)	bigint	bigint
binary	bytelen=10	binary(10)	bytea	blob	blob	binary(10)	binary(10)	char(10) for bit data	binary(10)	binary(10)	bytea	binary(10)	binary	binary	binary	char(2)	binary	byte(10)	binary(10)	binary(10)	raw(10)	raw(10)	raw(10)	blob	bytea	char(10)	binary(10)	binary(10)	byte(10)	char(10)
binary_double	bytelen=8	double	float	float	float	float	float	double	double	double	float	double	double	double	double	double	double	float	double	double	binary_double	binary_double	binary_double	float	float	float	float	float	float	float
binary_float	bytelen=4	float	real	real	real	real	real	real	real	real	real	real	float	float	float	float	float	float4	float	float	binary_float	binary_float	binary_float	real	real	real	real	float	float	float4
bit (mysql)	bitlen=32	bit(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	bit(32)	bit(32)	varchar2(32 byte)	varchar2(32 byte)	varchar2(32 byte)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32)	varchar(32) char set latin casespecific	varchar(32)
bit		tinyint	boolean	boolean	boolean	bit	bit	smallint	smallint	smallint	boolean	boolean	boolean	boolean	boolean	boolean	boolean	boolean	tinyint	tinyint	number(1)	number(1)	number(1)	boolean	boolean	boolean	bit	boolean	byteint	boolean
blob		longblob	bytea	blob	blob	varbinary(max)	varbinary(max)	blob(2147483647)	blob(2147483647)	blob(2147483647)	bytea	blob	binary	binary	binary	string	binary	long byte	longblob	longblob	blob	blob	blob	blob	bytea	varchar(65535)	varbinary(max)	binary(8388608)	blob(2097088000)	varchar(32000)
boolean		tinyint	boolean	boolean	boolean	bit	bit	smallint	smallint	smallint	boolean	boolean	boolean	boolean	boolean	boolean	boolean	boolean	tinyint	tinyint	number(1)	number(1)	number(1)	boolean	boolean	boolean	bit	boolean	byteint	boolean
byte varying	bytelen=10	varbinary(10)	bytea	blob	blob	varbinary(10)	varbinary(10)	varchar(10) for bit data	varbinary(10)	varbinary(10)	bytea	varbinary(10)	binary	binary	binary	string	binary	byte varying(10)	varbinary(10)	varbinary(10)	raw(10)	raw(10)	raw(10)	blob	bytea	varchar(10)	varbinary(10)	binary(10)	varbyte(10)	varchar(10)
byte	bytelen=10	binary(10)	bytea	blob	blob	binary(10)	binary(10)	char(10) for bit data	binary(10)	binary(10)	bytea	binary(10)	binary	binary	binary	char(2)	binary	byte(10)	binary(10)	binary(10)	raw(10)	raw(10)	raw(10)	blob	bytea	char(10)	binary(10)	binary(10)	byte(10)	char(10)
byteint	bytelen=1	tinyint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	i1	tinyint	tinyint	number(3)	number(3)	number(3)	smallint	smallint	smallint	smallint	number(38)	byteint	i1
c	bytelen=10encoding=UTF-8	char(10) charset utf8mb4	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(60)	char(10)	char(10)	char(10)	char(10)	char(10)	c10	char(10) charset utf8mb4	char(10) charset utf8mb4	char(10 byte)	char(20 char)	char(10 byte)	char(10)	char(10)	char(10)	char(10)	varchar(10)	char(10) char set latin casespecific	c10
char	bytelen=10encoding=UTF-8	char(10) charset utf8mb4	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(60)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10) charset utf8mb4	char(10) charset utf8mb4	char(10 byte)	char(20 char)	char(10 byte)	char(10)	char(10)	char(10)	char(10)	varchar(10)	char(10) char set latin casespecific	char(10)
char	bytelen=4000encoding=UTF-8	varchar(4000) charset utf8mb4	char(4000)	char(4000)	char(4000)	char(4000)	char(4000)	varchar(4000)	char(4000)	varchar(4000)	char(4000)	clob	varchar(4000)	varchar(4000)	varchar(4000)	varchar(4000)	varchar(4000)	char(4000)	varchar(4000) charset utf8mb4	varchar(4000) charset utf8mb4	varchar2(4000 byte)	clob	varchar2(4000 byte)	char(4000)	char(4000)	char(4000)	char(4000)	varchar(4000)	char(4000) char set latin casespecific	char(4000)
char	bytelen=8000encoding=UTF-8	varchar(8000) charset utf8mb4	char(8000)	char(8000)	char(8000)	char(8000)	char(8000)	varchar(8000)	char(8000)	varchar(8000)	char(8000)	clob	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	char(8000)	varchar(8000) charset utf8mb4	varchar(8000) charset utf8mb4	clob	clob	clob	char(8000)	char(8000)	varchar(8000)	char(8000)	varchar(8000)	char(8000) char set latin casespecific	char(8000)
char	bytelen=40charlen=10encoding=UTF-8	char(10) charset utf8mb4	char(10)	char(10)	char(10)	char(10)	char(10)	char(40)	char(10)	char(10)	char(10)	char(60)	char(10)	char(10)	char(10)	char(10)	char(10)	char(40)	char(10) charset utf8mb4	char(10) charset utf8mb4	char(10 char)	char(20 char)	char(10 byte)	char(10)	char(10)	char(40)	char(10)	varchar(10)	char(10) char set latin casespecific	char(40)
char	bytelen=10encoding=WINDOWS-1252	char(10) charset latin1	char(10)	char(10)	char(10)	char(10)	char(10)	char(20)	char(10)	char(10)	char(10)	char(20)	char(10)	char(10)	char(10)	char(10)	char(10)	char(20)	char(10) charset latin1	char(10) charset latin1	char(10 char)	char(10 char)	char(10 byte)	char(10)	char(10)	char(20)	char(10)	varchar(10)	char(10) char set latin casespecific	char(20)
char (oracle)	bytelen=10encoding=UTF-8	char(10) charset utf8mb4	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(60)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10)	char(10) charset utf8mb4	char(10) charset utf8mb4	char(10 byte)	char(20 char)	char(10 byte)	char(10)	char(10)	char(10)	char(10)	varchar(10)	char(10) char set latin casespecific	char(10)
char (oracle)	bytelen=2000encoding=UTF-8	varchar(2000) charset utf8mb4	char(2000)	char(2000)	char(2000)	char(2000)	char(2000)	varchar(2000)	char(2000)	varchar(2000)	char(2000)	clob	varchar(2000)	varchar(2000)	varchar(2000)	varchar(2000)	varchar(2000)	char(2000)	varchar(2000) charset utf8mb4	varchar(2000) charset utf8mb4	char(2000 byte)	clob	char(2000 byte)	char(2000)	char(2000)	char(2000)	char(2000)	varchar(2000)	char(2000) char set latin casespecific	char(2000)
char (oracle)	bytelen=40charlen=10encoding=UTF-8	char(10) charset utf8mb4	char(10)	char(10)	char(10)	char(10)	char(10)	char(40)	char(10)	char(10)	char(10)	char(60)	char(10)	char(10)	char(10)	char(10)	char(10)	char(40)	char(10) charset utf8mb4	char(10) charset utf8mb4	char(10 char)	char(20 char)	char(10 byte)	char(10)	char(10)	char(40)	char(10)	varchar(10)	char(10) char set latin casespecific	char(40)
char (oracle)	bytelen=10encoding=WINDOWS-1252	char(10) charset latin1	char(10)	char(10)	char(10)	char(10)	char(10)	char(20)	char(10)	char(10)	char(10)	char(20)	char(10)	char(10)	char(10)	char(10)	char(10)	char(20)	char(10) charset latin1	char(10) charset latin1	char(10 char)	char(10 char)	char(10 byte)	char(10)	char(10)	char(20)	char(10)	varchar(10)	char(10) char set latin casespecific	char(20)
clob	encoding=UTF-8	longtext charset utf8mb4	text	text	text	varchar(max)	varchar(max)	clob(2147483647)	clob(2147483647)	clob(2147483647)	text	clob	string	string	string	string	string	long varchar	longtext charset utf8mb4	longtext charset utf8mb4	clob	clob	clob	text	text	varchar(65535)	varchar(max)	varchar(16777216)	clob(2097088000) char set latin	varchar(32000)
date		datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	ingresdate	datetime(0)	datetime(0)	date	date	date	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	timestamp(0)
date (sybase)		date	date	bigint	date	date	date	date	date	date	date	date	date	date	date	date	date	ansidate	date	date	date	date	date	date	date	date	date	date	date	ansidate
datetime (mysql)	prec_sec=0	datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp(0) without time zone	datetime(0)	datetime(0)	timestamp(0)	timestamp(0)	timestamp(0)	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	timestamp(0)
datetime (sybase)		datetime(3)	timestamp(3)	varchar(100)	timestamp-millis	datetime2(3)	datetime2(3)	timestamp(3)	timestamp	timestamp(3)	timestamp(3)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	ingresdate	datetime(3)	datetime(3)	timestamp(6)	timestamp(6)	timestamp(6)	timestamp-millis	timestamp(3)	timestamp	datetime2(3)	timestamp_ntz(3)	timestamp(3)	ansidate
datetime		datetime(3)	timestamp(3)	varchar(100)	timestamp-millis	datetime	datetime	timestamp(3)	timestamp	timestamp(3)	timestamp(3)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	ingresdate	datetime(3)	datetime(3)	timestamp(6)	timestamp(6)	timestamp(6)	timestamp-millis	timestamp(3)	timestamp	datetime	timestamp_ntz(3)	timestamp(3)	ansidate
datetime2	prec_sec=0	datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp(0) without time zone	datetime(0)	datetime(0)	timestamp(0)	timestamp(0)	timestamp(0)	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	timestamp(0)
datetimeoffset		datetime(0)	timestamp(0) with time zone	varchar(100)	timestamp-millis	datetimeoffset(0)	datetimeoffset(0)	timestamp(0)	timestamp	timestamp(0) with time zone	timestamp(0) with time zone	timestamp	timestamp	timestamp	varchar(100)	timestamp	timestamp	timestamp(0) with time zone	datetime(0)	datetime(0)	timestamp(0) with time zone	timestamp(0) with time zone	timestamp(0) with time zone	timestamp-millis	timestamp(0) with time zone	timestamp	datetimeoffset(0)	timestamp_tz(0)	timestamp(0) with time zone	timestamp(0) with time zone
db2 timestamp with time zone	prec_sec=0	datetime(0)	timestamp(0) with time zone	varchar(100)	timestamp-millis	datetimeoffset(0)	datetimeoffset(0)	timestamp(0)	timestamp	timestamp(0) with time zone	timestamp(0) with time zone	timestamp	timestamp	timestamp	varchar(100)	timestamp	timestamp	timestamp(0) with time zone	datetime(0)	datetime(0)	timestamp(0) with time zone	timestamp(0) with time zone	timestamp(0) with time zone	timestamp-millis	timestamp(0) with time zone	timestamp	datetimeoffset(0)	timestamp_tz(0)	timestamp(0) with time zone	timestamp(0) with time zone
db2 xml	encoding=UTF-8	longtext charset utf8mb4	text	text	text	varchar(max)	xml	xml	clob(2147483647)	xml	text	clob	string	string	string	string	string	long varchar	longtext charset utf8mb4	longtext charset utf8mb4	clob	clob	clob	text	text	varchar(65535)	xml	varchar(16777216)	clob(2097088000) char set latin	varchar(32000)
dbclob		longtext charset utf8mb4	text	text	text	nvarchar(max)	nvarchar(max)	dbclob(1073741823)	dbclob(1073741823) CCSID 13488	dbclob(1073741823)	text	nclob	string	string	string	string	string	long nvarchar	longtext charset utf8mb4	longtext charset utf8mb4	nclob	nclob	nclob	text	text	varchar(65535)	nvarchar(max)	varchar(16777216)	clob(1048544000) char set unicode	nvarchar(16000)
decfloat	prec=16	varchar(42) charset utf8mb4	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	decfloat(16)	decfloat(16)	decfloat(16)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42) charset utf8mb4	varchar(42) charset utf8mb4	varchar2(42 byte)	varchar2(42 byte)	varchar2(42 byte)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42) char set latin casespecific	varchar(42)
decfloat	prec=34	varchar(42) charset utf8mb4	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	decfloat(34)	decfloat(34)	decfloat(34)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42) charset utf8mb4	varchar(42) charset utf8mb4	varchar2(42 byte)	varchar2(42 byte)	varchar2(42 byte)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42)	varchar(42) char set latin casespecific	varchar(42)
decimal	prec=10scale=3	decimal(10,3)	numeric(10,3)	varchar(12)	decimal(10,3)	numeric(10,3)	numeric(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	number(10,3)	number(10,3)	number(10,3)	decimal(10,3)	numeric(10,3)	decimal(10,3)	numeric(10,3)	number(10,3)	decimal(10,3)	decimal(10,3)
decimal	prec=6	decimal(6)	numeric(6)	varchar(8)	decimal(6)	numeric(6)	numeric(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	number(6)	number(6)	number(6)	decimal(6)	numeric(6)	decimal(6)	numeric(6)	number(6)	decimal(6)	decimal(6)
double	bytelen=8	double	float	float	float	float	float	double	double	double	float	double	double	double	double	double	double	float	double	double	binary_double	binary_double	binary_double	float	float	float	float	float	float	float
epoch		timestamp(0)null	timestamp(0)	bigint	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp(0) with local time zone	timestamp(0)null	timestamp(0)null	timestamp(0)	timestamp(0)	timestamp(0)	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	timestamp(0) with local time zone
float	bytelen=8	double	float	float	float	float	float	double	double	double	float	double	double	double	double	double	double	float	double	double	binary_double	binary_double	binary_double	float	float	float	float	float	float	float
float4	bytelen=4	float	real	real	real	real	real	real	real	real	real	real	float	float	float	float	float	float4	float	float	binary_float	binary_float	binary_float	real	real	real	real	float	float	float4
float8	bytelen=8	double	float	float	float	float	float	double	double	double	float	double	double	double	double	double	double	float	double	double	binary_double	binary_double	binary_double	float	float	float	float	float	float	float
graphic	charlen=10	char(10) charset utf8mb4	char(10)	char(10)	char(10)	nchar(10)	nchar(10)	graphic(10)	nchar(10)	graphic(10)	char(10)	nchar(10)	char(10)	char(10)	char(10)	char(10)	char(10)	nchar(10)	char(10) charset utf8mb4	char(10) charset utf8mb4	nchar(10)	nchar(10)	nchar(10)	char(10)	char(10)	varchar(40)	nchar(10)	varchar(10)	char(10) char set unicode casespecific	nchar(10)
image		longblob	bytea	blob	blob	varbinary(max)	varbinary(max)	blob(2147483647)	blob(2147483647)	blob(2147483647)	bytea	blob	binary	binary	binary	string	binary	long byte	longblob	longblob	blob	blob	blob	blob	bytea	varchar(65535)	varbinary(max)	binary(8388608)	blob(2097088000)	varchar(32000)
image (sybase)		longblob	bytea	blob	blob	varbinary(max)	varbinary(max)	blob(2147483647)	blob(2147483647)	blob(2147483647)	bytea	blob	binary	binary	binary	string	binary	long byte	longblob	longblob	long raw	long raw	long raw	blob	bytea	varchar(65535)	varbinary(max)	binary(8388608)	blob(2097088000)	varchar(32000)
ingresdate		datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	ingresdate	datetime(0)	datetime(0)	date	date	date	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	timestamp(0)
int unsigned	bytelen=4	int unsigned	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	int unsigned	int unsigned	number(10)	number(10)	number(10)	bigint	bigint	bigint	bigint	number(38)	bigint	bigint
int	bytelen=4	int	integer	integer	integer	int	int	integer	integer	integer	integer	integer	int	int	int	int	int	integer	int	int	number(10)	number(10)	number(10)	integer	integer	integer	int	number(38)	integer	integer
integer	bytelen=4	int	integer	integer	integer	int	int	integer	integer	integer	integer	integer	int	int	int	int	int	integer	int	int	number(10)	number(10)	number(10)	integer	integer	integer	int	number(38)	integer	integer
integer1	bytelen=1	tinyint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	i1	tinyint	tinyint	number(3)	number(3)	number(3)	smallint	smallint	smallint	smallint	number(38)	byteint	i1
integer2	bytelen=2	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	number(5)	number(5)	number(5)	smallint	smallint	smallint	smallint	number(38)	smallint	smallint
integer4	bytelen=4	int	integer	integer	integer	int	int	integer	integer	integer	integer	integer	int	int	int	int	int	integer	int	int	number(10)	number(10)	number(10)	integer	integer	integer	int	number(38)	integer	integer
integer8	bytelen=8	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	number(19)	number(19)	number(19)	bigint	bigint	bigint	bigint	number(38)	bigint	bigint
interval day to second (ingres)		datetime(0)	timestamp(0)	varchar(100)	interval month to second	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	interval day to second(0)	datetime(0)	datetime(0)	interval day(9) to second(0)	interval day(9) to second(0)	interval day(9) to second(0)	interval month to second	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	interval day to second(0)
interval day to second		datetime(0)	timestamp(0)	varchar(100)	interval month to second	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	interval day to second(0)	datetime(0)	datetime(0)	interval day(0) to second(0)	interval day(0) to second(0)	interval day(0) to second(0)	interval month to second	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	interval day to second(0)
interval month to second		datetime(0)	timestamp(0)	varchar(100)	interval month to second	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	interval day to second(0)	datetime(0)	datetime(0)	interval day(9) to second(0)	interval day(9) to second(0)	interval day(9) to second(0)	interval month to second	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	interval day to second(0)
interval year to month (ingres)		datetime(0)	timestamp(6)	varchar(100)	interval month to second	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(6)	timestamp	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	interval year to month	datetime(0)	datetime(0)	interval year(0) to month	interval year(0) to month	interval year(0) to month	interval month to second	timestamp(6)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	interval year to month
interval year to month		datetime(0)	timestamp(6)	varchar(100)	interval month to second	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(6)	timestamp	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	interval year to month	datetime(0)	datetime(0)	interval year(0) to month	interval year(0) to month	interval year(0) to month	interval month to second	timestamp(6)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	interval year to month
json		longtext charset utf8mb4	json	text	text	varchar(max)	varchar(max)	clob(2147483647)	clob(2147483647)	clob(2147483647)	text	clob	string	string	string	string	string	long varchar	longtext charset utf8mb4	longtext charset utf8mb4	clob	clob	clob	text	json	varchar(65535)	varchar(max)	varchar(16777216)	clob(2097088000) char set latin	varchar(32000)
jsonb		longtext charset utf8mb4	jsonb	text	text	varchar(max)	varchar(max)	clob(2147483647)	clob(2147483647)	clob(2147483647)	text	clob	string	string	string	string	string	long varchar	longtext charset utf8mb4	longtext charset utf8mb4	clob	clob	clob	text	jsonb	varchar(65535)	varchar(max)	varchar(16777216)	clob(2097088000) char set latin	varchar(32000)
long byte		longblob	bytea	blob	blob	varbinary(max)	varbinary(max)	blob(2147483647)	blob(2147483647)	blob(2147483647)	bytea	blob	binary	binary	binary	string	binary	long byte	longblob	longblob	blob	blob	blob	blob	bytea	varchar(65535)	varbinary(max)	binary(8388608)	blob(2097088000)	varchar(32000)
long char	encoding=UTF-8	longtext charset utf8mb4	char	text	text	varchar(max)	varchar(max)	clob(2147483647)	clob(2147483647)	clob(2147483647)	char	clob	string	string	string	string	string	long varchar	longtext charset utf8mb4	longtext charset utf8mb4	clob	clob	clob	text	char	varchar(65535)	varchar(max)	varchar(16777216)	clob(2097088000) char set latin	varchar(32000)
long nvarchar (db2)		longtext charset utf8mb4	text	text	text	nvarchar(max)	nvarchar(max)	long vargraphic	dbclob(1073741823) CCSID 13488	dbclob(1073741823)	text	nclob	string	string	string	string	string	long nvarchar	longtext charset utf8mb4	longtext charset utf8mb4	nclob	nclob	nclob	text	text	varchar(65535)	nvarchar(max)	varchar(16777216)	clob(1048544000) char set unicode	nvarchar(16000)
long nvarchar		longtext charset utf8mb4	text	text	text	nvarchar(max)	nvarchar(max)	dbclob(1073741823)	dbclob(1073741823) CCSID 13488	dbclob(1073741823)	text	nclob	string	string	string	string	string	long nvarchar	longtext charset utf8mb4	longtext charset utf8mb4	nclob	nclob	nclob	text	text	varchar(65535)	nvarchar(max)	varchar(16777216)	clob(1048544000) char set unicode	nvarchar(16000)
long raw		longblob	bytea	blob	blob	varbinary(max)	varbinary(max)	blob(2147483647)	blob(2147483647)	blob(2147483647)	bytea	blob	binary	binary	binary	string	binary	long byte	longblob	longblob	long raw	long raw	long raw	blob	bytea	varchar(65535)	varbinary(max)	binary(8388608)	blob(2097088000)	varchar(32000)
long varbinary		longblob	bytea	blob	blob	varbinary(max)	varbinary(max)	long varchar for bit data	blob(2147483647)	blob(2147483647)	bytea	blob	binary	binary	binary	string	binary	long byte	longblob	longblob	blob	blob	blob	blob	bytea	varchar(65535)	varbinary(max)	binary(8388608)	blob(2097088000)	varchar(32000)
long varchar (db2)	encoding=UTF-8	longtext charset utf8mb4	text	text	text	varchar(max)	varchar(max)	long varchar	clob(2147483647)	clob(2147483647)	text	clob	string	string	string	string	string	long varchar	longtext charset utf8mb4	longtext charset utf8mb4	clob	clob	clob	text	text	varchar(65535)	varchar(max)	varchar(16777216)	clob(2097088000) char set latin	varchar(32000)
long varchar	encoding=UTF-8	longtext charset utf8mb4	text	text	text	varchar(max)	varchar(max)	clob(2147483647)	clob(2147483647)	clob(2147483647)	text	clob	string	string	string	string	string	long varchar	longtext charset utf8mb4	longtext charset utf8mb4	clob	clob	clob	text	text	varchar(65535)	varchar(max)	varchar(16777216)	clob(2097088000) char set latin	varchar(32000)
long	encoding=UTF-8	longtext charset utf8mb4	text	text	text	varchar(max)	varchar(max)	clob(2147483647)	clob(2147483647)	clob(2147483647)	text	clob	string	string	string	string	string	long varchar	longtext charset utf8mb4	longtext charset utf8mb4	long	long	long	text	text	varchar(65535)	varchar(max)	varchar(16777216)	clob(2097088000) char set latin	varchar(32000)
mediumint unsigned	bytelen=3	mediumint unsigned	integer	integer	integer	int	int	integer	integer	integer	integer	integer	int	int	int	int	int	integer	mediumint unsigned	mediumint unsigned	number(8)	number(8)	number(8)	integer	integer	integer	int	number(38)	integer	integer
mediumint	bytelen=3	mediumint	integer	integer	integer	int	int	integer	integer	integer	integer	integer	int	int	int	int	int	integer	mediumint	mediumint	number	number	number	integer	integer	integer	int	number(38)	integer	integer
money (ingres)		decimal(14,2)	numeric(14,2)	varchar(16)	decimal(14,2)	money	money	decimal(14,2)	decimal(14,2)	decimal(14,2)	decimal(14,2)	decimal(14,2)	decimal(14,2)	decimal(14,2)	decimal(14,2)	decimal(14,2)	decimal(14,2)	money	decimal(14,2)	decimal(14,2)	number(14,2)	number(14,2)	number(14,2)	decimal(14,2)	numeric(14,2)	decimal(14,2)	money	number(14,2)	decimal(14,2)	money
money		decimal(19,4)	numeric(19,4)	varchar(21)	decimal(19,4)	money	money	decimal(19,4)	decimal(19,4)	decimal(19,4)	decimal(19,4)	decimal(19,4)	decimal(19,4)	decimal(19,4)	decimal(19,4)	decimal(19,4)	decimal(19,4)	money	decimal(19,4)	decimal(19,4)	number(19,4)	number(19,4)	number(19,4)	decimal(19,4)	numeric(19,4)	decimal(19,4)	money	number(19,4)	decimal(19,4)	money
nchar	charlen=10	char(10) charset utf8mb4	char(10)	char(10)	char(10)	nchar(10)	nchar(10)	graphic(10)	nchar(10)	graphic(10)	char(10)	nchar(10)	char(10)	char(10)	char(10)	char(10)	char(10)	nchar(10)	char(10) charset utf8mb4	char(10) charset utf8mb4	nchar(10)	nchar(10)	nchar(10)	char(10)	char(10)	varchar(40)	nchar(10)	varchar(10)	char(10) char set unicode casespecific	nchar(10)
nchar (oracle)	charlen=10	char(10) charset utf8mb4	char(10)	char(10)	char(10)	nchar(10)	nchar(10)	graphic(10)	nchar(10)	graphic(10)	char(10)	nchar(10)	char(10)	char(10)	char(10)	char(10)	char(10)	nchar(10)	char(10) charset utf8mb4	char(10) charset utf8mb4	nchar(10)	nchar(10)	nchar(10)	char(10)	char(10)	varchar(40)	nchar(10)	varchar(10)	char(10) char set unicode casespecific	nchar(10)
nclob		longtext charset utf8mb4	text	text	text	nvarchar(max)	nvarchar(max)	dbclob(1073741823)	dbclob(1073741823) CCSID 13488	dbclob(1073741823)	text	nclob	string	string	string	string	string	long nvarchar	longtext charset utf8mb4	longtext charset utf8mb4	nclob	nclob	nclob	text	text	varchar(65535)	nvarchar(max)	varchar(16777216)	clob(1048544000) char set unicode	nvarchar(16000)
ntext		longtext charset utf8mb4	text	text	text	nvarchar(max)	nvarchar(max)	dbclob(1073741823)	dbclob(1073741823) CCSID 13488	dbclob(1073741823)	text	nclob	string	string	string	string	string	long nvarchar	longtext charset utf8mb4	longtext charset utf8mb4	nclob	nclob	nclob	text	text	varchar(65535)	nvarchar(max)	varchar(16777216)	clob(1048544000) char set unicode	nvarchar(16000)
number		decimal(65,4)	numeric	float	decimal(1000,4)	numeric(38,4)	numeric(38,4)	decimal(31,4)	decimal(63,4)	decimal(31,4)	numeric	decimal	decimal(38,4)	decimal(38,4)	decimal(38,4)	decimal(38,4)	decimal(38,4)	decimal(39,4)	decimal(65,4)	decimal(65,4)	number	number	number	decimal(1000,4)	numeric	decimal(38,4)	numeric(38,4)	number(38,4)	number	decimal(38,4)
number	prec=10scale=-127	double	float	float	float	float	float	double	double	double	float	double	double	double	double	double	double	float	double	double	float(10)	float(10)	float(10)	float	float	float	float	float	float	float
number	prec=10scale=3	decimal(10,3)	numeric(10,3)	float	decimal(10,3)	numeric(10,3)	numeric(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	number(10,3)	number(10,3)	number(10,3)	decimal(10,3)	numeric(10,3)	decimal(10,3)	numeric(10,3)	number(10,3)	number(10,3)	decimal(10,3)
number	prec=26	decimal(26)	numeric(26)	float	decimal(26)	numeric(26)	numeric(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	number(26)	number(26)	number(26)	decimal(26)	numeric(26)	decimal(26)	numeric(26)	number(26)	number(26)	decimal(26)
number	prec=6	int	numeric(6)	integer	integer	int	int	integer	integer	integer	decimal(6)	decimal(6)	int	int	int	int	int	integer	int	int	number(6)	number(6)	number(6)	integer	numeric(6)	integer	int	number(6)	number(6)	integer
numeric (db2i)	prec=10scale=3	decimal(10,3)	numeric(10,3)	varchar(12)	decimal(10,3)	numeric(10,3)	numeric(10,3)	decimal(10,3)	numeric(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	number(10,3)	number(10,3)	number(10,3)	decimal(10,3)	numeric(10,3)	decimal(10,3)	numeric(10,3)	number(10,3)	decimal(10,3)	decimal(10,3)
numeric (db2i)	prec=6	decimal(6)	numeric(6)	varchar(8)	decimal(6)	numeric(6)	numeric(6)	decimal(6)	numeric(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	number(6)	number(6)	number(6)	decimal(6)	numeric(6)	decimal(6)	numeric(6)	number(6)	decimal(6)	decimal(6)
numeric	prec=10scale=3	decimal(10,3)	numeric(10,3)	varchar(12)	decimal(10,3)	numeric(10,3)	numeric(10,3)	decimal(10,3)	numeric(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	decimal(10,3)	number(10,3)	number(10,3)	number(10,3)	decimal(10,3)	numeric(10,3)	decimal(10,3)	numeric(10,3)	number(10,3)	decimal(10,3)	decimal(10,3)
numeric	prec=26	decimal(26)	numeric(26)	varchar(28)	decimal(26)	numeric(26)	numeric(26)	decimal(26)	numeric(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	decimal(26)	number(26)	number(26)	number(26)	decimal(26)	numeric(26)	decimal(26)	numeric(26)	number(26)	decimal(26)	decimal(26)
numeric	prec=6	decimal(6)	numeric(6)	varchar(8)	decimal(6)	numeric(6)	numeric(6)	decimal(6)	numeric(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	decimal(6)	number(6)	number(6)	number(6)	decimal(6)	numeric(6)	decimal(6)	numeric(6)	number(6)	decimal(6)	decimal(6)
nvarchar	charlen=10	varchar(10) charset utf8mb4	varchar(10)	varchar(10)	varchar(10)	nvarchar(10)	nvarchar(10)	vargraphic(10)	nvarchar(10)	vargraphic(10)	varchar(10)	nvarchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	nvarchar(10)	varchar(10) charset utf8mb4	varchar(10) charset utf8mb4	nvarchar2(10)	nvarchar2(10)	nvarchar2(10)	varchar(10)	varchar(10)	varchar(40)	nvarchar(10)	varchar(10)	varchar(10) char set unicode casespecific	nvarchar(10)
nvarchar(max)		longtext charset utf8mb4	text	text	text	nvarchar(max)	nvarchar(max)	dbclob(1073741823)	dbclob(1073741823) CCSID 13488	dbclob(1073741823)	text	nclob	string	string	string	string	string	long nvarchar	longtext charset utf8mb4	longtext charset utf8mb4	nclob	nclob	nclob	text	text	varchar(65535)	nvarchar(max)	varchar(16777216)	clob(1048544000) char set unicode	nvarchar(16000)
nvarchar2	charlen=10	varchar(10) charset utf8mb4	varchar(10)	varchar(10)	varchar(10)	nvarchar(10)	nvarchar(10)	vargraphic(10)	nvarchar(10)	vargraphic(10)	varchar(10)	nvarchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	nvarchar(10)	varchar(10) charset utf8mb4	varchar(10) charset utf8mb4	nvarchar2(10)	nvarchar2(10)	nvarchar2(10)	varchar(10)	varchar(10)	varchar(40)	nvarchar(10)	varchar(10)	varchar(10) char set unicode casespecific	nvarchar(10)
postgres date		date	date	bigint	date	date	date	date	date	date	date	date	date	date	date	date	date	ansidate	date	date	date	date	date	date	date	date	date	date	date	ansidate
postgres timestamp with time zone		datetime(0)	timestamp(0) with time zone	varchar(100)	timestamp-millis	datetimeoffset(0)	datetimeoffset(0)	timestamp(0)	timestamp	timestamp(0) with time zone	timestamp(0) with time zone	timestamp	timestamp	timestamp	varchar(100)	timestamp	timestamp	timestamp(0) with time zone	datetime(0)	datetime(0)	timestamp(0) with time zone	timestamp(0) with time zone	timestamp(0) with time zone	timestamp-millis	timestamp(0) with time zone	timestamp	datetimeoffset(0)	timestamp_tz(0)	timestamp(0) with time zone	timestamp(0) with time zone
postgres timestamp		datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp(0) without time zone	datetime(0)	datetime(0)	timestamp(0)	timestamp(0)	timestamp(0)	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	timestamp(0)
raw	bytelen=10	varbinary(10)	bytea	blob	blob	varbinary(10)	varbinary(10)	varchar(10) for bit data	varbinary(10)	varbinary(10)	bytea	varbinary(10)	binary	binary	binary	string	binary	byte varying(10)	varbinary(10)	varbinary(10)	raw(10)	raw(10)	raw(10)	blob	bytea	varchar(10)	varbinary(10)	binary(10)	varbyte(10)	varchar(10)
real	bytelen=4	float	real	real	real	real	real	real	real	real	real	real	float	float	float	float	float	float4	float	float	binary_float	binary_float	binary_float	real	real	real	real	float	float	float4
rowid		char(18) charset ascii	char(18)	char(18)	char(18)	char(18)	char(18)	char(18)	char(18)	char(18)	char(18)	char(18)	char(18)	char(18)	char(18)	char(18)	char(18)	char(18)	char(18) charset ascii	char(18) charset ascii	rowid	rowid	rowid	char(18)	char(18)	char(18)	char(18)	varchar(18)	char(18) char set latin casespecific	char(18)
rowversion	bytelen=10	binary(10)	bytea	blob	blob	binary(10)	binary(10)	char(10) for bit data	binary(10)	binary(10)	bytea	binary(10)	binary	binary	binary	char(2)	binary	byte(10)	binary(10)	binary(10)	raw(10)	raw(10)	raw(10)	blob	bytea	char(10)	binary(10)	binary(10)	byte(10)	char(10)
smalldatetime		datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	smalldatetime	smalldatetime	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	ingresdate	datetime(0)	datetime(0)	date	date	date	timestamp-millis	timestamp(0)	timestamp	smalldatetime	timestamp_ntz(0)	timestamp(0)	ansidate
smallint unsigned	bytelen=2	smallint unsigned	integer	integer	integer	int	int	integer	integer	integer	integer	integer	int	int	int	int	int	integer	smallint unsigned	smallint unsigned	number(5)	number(5)	number(5)	integer	integer	integer	int	number(38)	integer	integer
smallint	bytelen=2	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	number(5)	number(5)	number(5)	smallint	smallint	smallint	smallint	number(38)	smallint	smallint
smallmoney		decimal(10,4)	numeric(10,4)	varchar(12)	decimal(10,4)	smallmoney	smallmoney	decimal(10,4)	decimal(10,4)	decimal(10,4)	decimal(10,4)	decimal(10,4)	decimal(10,4)	decimal(10,4)	decimal(10,4)	decimal(10,4)	decimal(10,4)	decimal(10,4)	decimal(10,4)	decimal(10,4)	number(10,4)	number(10,4)	number(10,4)	decimal(10,4)	numeric(10,4)	decimal(10,4)	smallmoney	number(10,4)	decimal(10,4)	decimal(10,4)
text (ingres)	bytelen=10encoding=UTF-8	varchar(10) charset utf8mb4	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(60)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	text(10)	varchar(10) charset utf8mb4	varchar(10) charset utf8mb4	varchar2(10 byte)	varchar2(20 char)	varchar2(10 byte)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10) char set latin casespecific	text(10)
text (sqlserver)	encoding=WINDOWS-1252	longtext charset latin1	text	text	text	varchar(max)	varchar(max)	clob(2147483647)	clob(2147483647)	clob(2147483647)	text	clob	string	string	string	string	string	long varchar	longtext charset latin1	longtext charset latin1	clob	clob	clob	text	text	varchar(65535)	varchar(max)	varchar(16777216)	clob(2097088000) char set latin	varchar(32000)
text(sybase)	encoding=UTF-8	longtext charset utf8mb4	text	text	text	varchar(max)	varchar(max)	clob(2147483647)	clob(2147483647)	clob(2147483647)	text	clob	string	string	string	string	string	long varchar	longtext charset utf8mb4	longtext charset utf8mb4	long	long	long	text	text	varchar(65535)	varchar(max)	varchar(16777216)	clob(2097088000) char set latin	varchar(32000)
time (mysql)	prec_sec=0	time(0)	time(0)	integer	time(3)	time(0)	time(0)	time	time	time	time(0)	time	varchar(25)	varchar(25)	varchar(25)	varchar(25)	varchar(25)	time(0) without time zone	time(0)	time(0)	timestamp(0)	timestamp(0)	timestamp(0)	time(3)	time(0)	timestamp	time(0)	time(0)	time(0)	time(0) without time zone
time (sybase)	prec_sec=0	time(3)	time(3)	integer	time(3)	time(3)	time(3)	time	time	time	time(3)	time	varchar(25)	varchar(25)	varchar(25)	varchar(25)	varchar(25)	time(3) without time zone	time(3)	time(3)	timestamp(3)	timestamp(3)	timestamp(3)	time(3)	time(3)	timestamp	time(3)	time(3)	time(3)	time(3) without time zone
time with local time zone		time(0)	time(0)	integer	time(3)	time(0)	time(0)	time	time	time	time(0)	time	varchar(25)	varchar(25)	varchar(25)	varchar(25)	varchar(25)	time(0) with local time zone	time(0)	time(0)	timestamp(0) with local time zone	timestamp(0) with local time zone	timestamp(0) with local time zone	time(3)	time(0)	timestamp	time(0)	time(0)	time(0)	time(0) with local time zone
time with time zone		time(0)	time(0) with time zone	integer	time(3)	time(0)	time(0)	time	time	time	time(0)	time	varchar(25)	varchar(25)	varchar(25)	varchar(25)	varchar(25)	time(0) with time zone	time(0)	time(0)	timestamp(0) with time zone	timestamp(0) with time zone	timestamp(0) with time zone	time(3)	time(0) with time zone	timestamp	time(0)	time(0)	time(0) with time zone	time(0) with time zone
time	prec_sec=0	time(0)	time(0)	integer	time(3)	time(0)	time(0)	time	time	time	time(0)	time	varchar(25)	varchar(25)	varchar(25)	varchar(25)	varchar(25)	time(0) without time zone	time(0)	time(0)	timestamp(0)	timestamp(0)	timestamp(0)	time(3)	time(0)	timestamp	time(0)	time(0)	time(0)	time(0) without time zone
time	prec_sec=3	time(3)	time(3)	integer	time(3)	time(3)	time(3)	time	time	time	time(3)	time	varchar(25)	varchar(25)	varchar(25)	varchar(25)	varchar(25)	time(3) without time zone	time(3)	time(3)	timestamp(3)	timestamp(3)	timestamp(3)	time(3)	time(3)	timestamp	time(3)	time(3)	time(3)	time(3) without time zone
time2		time(6)	time(0)	integer	time(3)	time(0)	time(0)	time	time	time	time(0)	time	varchar(25)	varchar(25)	varchar(25)	varchar(25)	varchar(25)	time(0) without time zone	time(6)	time(6)	timestamp(0)	timestamp(0)	timestamp(0)	time(3)	time(0)	timestamp	time(0)	time(0)	time(0)	time(0) without time zone
timestamp (db2)	prec_sec=0	datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp(0) without time zone	datetime(0)	datetime(0)	timestamp(0)	timestamp(0)	timestamp(0)	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	timestamp(0)
timestamp (ingres)		datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp(0) without time zone	datetime(0)	datetime(0)	timestamp(0)	timestamp(0)	timestamp(0)	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	timestamp(0)
timestamp (mysql)		timestamp(0)null	timestamp(0)	bigint	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp(0) with local time zone	timestamp(0)null	timestamp(0)null	timestamp(0)	timestamp(0)	timestamp(0)	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	timestamp(0) with local time zone
timestamp (oracle)		datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp(0) without time zone	datetime(0)	datetime(0)	timestamp(0)	timestamp(0)	timestamp(0)	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	timestamp(0)
timestamp (sqlserver)	bytelen=10	binary(10)	bytea	blob	blob	binary(10)	binary(10)	char(10) for bit data	binary(10)	binary(10)	bytea	binary(10)	binary	binary	binary	char(2)	binary	byte(10)	binary(10)	binary(10)	raw(10)	raw(10)	raw(10)	blob	bytea	char(10)	binary(10)	binary(10)	byte(10)	char(10)
timestamp (sybase)	bytelen=10	varbinary(10)	bytea	blob	blob	varbinary(10)	varbinary(10)	varchar(10) for bit data	varbinary(10)	varbinary(10)	bytea	varbinary(10)	binary	binary	binary	string	binary	byte varying(10)	varbinary(10)	varbinary(10)	raw(10)	raw(10)	raw(10)	blob	bytea	varchar(10)	varbinary(10)	binary(10)	varbyte(10)	varchar(10)
timestamp with local time zone		datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	varchar(100)	timestamp	timestamp	timestamp(0) with local time zone	datetime(0)	datetime(0)	timestamp(0) with local time zone	timestamp(0) with local time zone	timestamp(0) with local time zone	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ltz(0)	timestamp(0)	timestamp(0) with local time zone
timestamp with local tz (oracle)		datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	varchar(100)	timestamp	timestamp	timestamp(0) with local time zone	datetime(0)	datetime(0)	timestamp(0) with local time zone	timestamp(0) with local time zone	timestamp(0) with local time zone	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ltz(0)	timestamp(0)	timestamp(0) with local time zone
timestamp with time zone		datetime(0)	timestamp(0) with time zone	varchar(100)	timestamp-millis	datetimeoffset(0)	datetimeoffset(0)	timestamp(0)	timestamp	timestamp(0) with time zone	timestamp(0) with time zone	timestamp	timestamp	timestamp	varchar(100)	timestamp	timestamp	timestamp(0) with time zone	datetime(0)	datetime(0)	timestamp(0) with time zone	timestamp(0) with time zone	timestamp(0) with time zone	timestamp-millis	timestamp(0) with time zone	timestamp	datetimeoffset(0)	timestamp_tz(0)	timestamp(0) with time zone	timestamp(0) with time zone
timestamp with tz (oracle)		datetime(0)	timestamp(0) with time zone	varchar(100)	timestamp-millis	datetimeoffset(0)	datetimeoffset(0)	timestamp(0)	timestamp	timestamp(0) with time zone	timestamp(0) with time zone	timestamp	timestamp	timestamp	varchar(100)	timestamp	timestamp	timestamp(0) with time zone	datetime(0)	datetime(0)	timestamp(0) with time zone	timestamp(0) with time zone	timestamp(0) with time zone	timestamp-millis	timestamp(0) with time zone	timestamp	datetimeoffset(0)	timestamp_tz(0)	timestamp(0) with time zone	timestamp(0) with time zone
timestamp	prec_sec=0	datetime(0)	timestamp(0)	varchar(100)	timestamp-millis	datetime2(0)	datetime2(0)	timestamp(0)	timestamp	timestamp(0)	timestamp(0)	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp	timestamp(0) without time zone	datetime(0)	datetime(0)	timestamp(0)	timestamp(0)	timestamp(0)	timestamp-millis	timestamp(0)	timestamp	datetime2(0)	timestamp_ntz(0)	timestamp(0)	timestamp(0)
tinyint signed	bytelen=1	tinyint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	smallint	i1	tinyint	tinyint	number(3)	number(3)	number(3)	smallint	smallint	smallint	smallint	number(38)	byteint	i1
tinyint unsigned	bytelen=1	tinyint unsigned	smallint	smallint	smallint	tinyint	tinyint	smallint	smallint	smallint	smallint	tinyint	smallint	smallint	smallint	smallint	smallint	smallint	tinyint unsigned	tinyint unsigned	number(3)	number(3)	number(3)	smallint	smallint	smallint	tinyint	number(38)	smallint	smallint
tinyint	bytelen=1	tinyint unsigned	smallint	smallint	smallint	tinyint	tinyint	smallint	smallint	smallint	smallint	tinyint	smallint	smallint	smallint	smallint	smallint	smallint	tinyint unsigned	tinyint unsigned	number(3)	number(3)	number(3)	smallint	smallint	smallint	tinyint	number(38)	smallint	smallint
uniqueidentifier		binary(16)	char(36)	char(36)	char(36)	uniqueidentifier	uniqueidentifier	char(16) for bit data	binary(16)	binary(16)	char(36)	binary(16)	char(36)	char(36)	char(36)	char(36)	char(36)	byte(16)	binary(16)	binary(16)	raw(16)	raw(16)	raw(16)	char(36)	char(36)	char(36)	uniqueidentifier	binary(16)	byte(16)	char(36)
unitext		longtext charset utf8mb4	text	text	text	nvarchar(max)	nvarchar(max)	dbclob(1073741823)	dbclob(1073741823) CCSID 13488	dbclob(1073741823)	text	nclob	string	string	string	string	string	long nvarchar	longtext charset utf8mb4	longtext charset utf8mb4	nclob	nclob	nclob	text	text	varchar(65535)	nvarchar(max)	varchar(16777216)	clob(1048544000) char set unicode	nvarchar(16000)
univarchar	charlen=10	varchar(10) charset utf8mb4	varchar(10)	varchar(10)	varchar(10)	nvarchar(10)	nvarchar(10)	vargraphic(10)	nvarchar(10)	vargraphic(10)	varchar(10)	nvarchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	nvarchar(10)	varchar(10) charset utf8mb4	varchar(10) charset utf8mb4	nvarchar2(10)	nvarchar2(10)	nvarchar2(10)	varchar(10)	varchar(10)	varchar(40)	nvarchar(10)	varchar(10)	varchar(10) char set unicode casespecific	nvarchar(10)
unsigned bigint	bytelen=8	bigint unsigned	numeric(20)	float	decimal(20)	numeric(20)	numeric(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	decimal(20)	bigint unsigned	bigint unsigned	number(20)	number(20)	number(20)	decimal(20)	numeric(20)	decimal(20)	numeric(20)	number(38)	decimal(20)	decimal(20)
unsigned int	bytelen=4	int unsigned	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	bigint	int unsigned	int unsigned	number(10)	number(10)	number(10)	bigint	bigint	bigint	bigint	number(38)	bigint	bigint
unsigned smallint	bytelen=2	smallint unsigned	integer	integer	integer	int	int	integer	integer	integer	integer	integer	int	int	int	int	int	integer	smallint unsigned	smallint unsigned	number(5)	number(5)	number(5)	integer	integer	integer	int	number(38)	integer	integer
urowid	bytelen=100	varchar(100) charset ascii	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100) charset ascii	varchar(100) charset ascii	urowid(75)	urowid(75)	urowid(75)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100)	varchar(100) char set latin casespecific	varchar(100)
varbinary	bytelen=10	varbinary(10)	bytea	blob	blob	varbinary(10)	varbinary(10)	varchar(10) for bit data	varbinary(10)	varbinary(10)	bytea	varbinary(10)	binary	binary	binary	string	binary	byte varying(10)	varbinary(10)	varbinary(10)	raw(10)	raw(10)	raw(10)	blob	bytea	varchar(10)	varbinary(10)	binary(10)	varbyte(10)	varchar(10)
varbinary (sybase)	bytelen=10	varbinary(10)	bytea	blob	blob	varbinary(10)	varbinary(10)	varchar(10) for bit data	varbinary(10)	varbinary(10)	bytea	varbinary(10)	binary	binary	binary	string	binary	byte varying(10)	varbinary(10)	varbinary(10)	raw(10)	raw(10)	raw(10)	blob	bytea	varchar(10)	varbinary(10)	binary(10)	varbyte(10)	varchar(10)
varbinary(max)		longblob	bytea	blob	blob	varbinary(max)	varbinary(max)	blob(2147483647)	blob(2147483647)	blob(2147483647)	bytea	blob	binary	binary	binary	string	binary	long byte	longblob	longblob	blob	blob	blob	blob	bytea	varchar(65535)	varbinary(max)	binary(8388608)	blob(2097088000)	varchar(32000)
varbyte	bytelen=10	varbinary(10)	bytea	blob	blob	varbinary(10)	varbinary(10)	varchar(10) for bit data	varbinary(10)	varbinary(10)	bytea	varbinary(10)	binary	binary	binary	string	binary	byte varying(10)	varbinary(10)	varbinary(10)	raw(10)	raw(10)	raw(10)	blob	bytea	varchar(10)	varbinary(10)	binary(10)	varbyte(10)	varchar(10)
varchar	bytelen=10encoding=UTF-8	varchar(10) charset utf8mb4	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(60)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10) charset utf8mb4	varchar(10) charset utf8mb4	varchar2(10 byte)	varchar2(20 char)	varchar2(10 byte)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10) char set latin casespecific	varchar(10)
varchar	bytelen=8000encoding=UTF-8	varchar(8000) charset utf8mb4	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	clob	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000) charset utf8mb4	varchar(8000) charset utf8mb4	clob	clob	clob	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000) char set latin casespecific	varchar(8000)
varchar	bytelen=40charlen=10encoding=UTF-8	varchar(10) charset utf8mb4	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(40)	varchar(10)	varchar(10)	varchar(10)	varchar(60)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(40)	varchar(10) charset utf8mb4	varchar(10) charset utf8mb4	varchar2(10 char)	varchar2(20 char)	varchar2(10 byte)	varchar(10)	varchar(10)	varchar(40)	varchar(10)	varchar(10)	varchar(10) char set latin casespecific	varchar(40)
varchar	bytelen=10encoding=WINDOWS-1252	varchar(10) charset latin1	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(20)	varchar(10)	varchar(10)	varchar(10)	varchar(20)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(20)	varchar(10) charset latin1	varchar(10) charset latin1	varchar2(10 char)	varchar2(10 char)	varchar2(10 byte)	varchar(10)	varchar(10)	varchar(20)	varchar(10)	varchar(10)	varchar(10) char set latin casespecific	varchar(20)
varchar (sybase)	bytelen=10encoding=UTF-8	varchar(10) charset utf8mb4	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(60)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10) charset utf8mb4	varchar(10) charset utf8mb4	varchar2(10 byte)	varchar2(20 char)	varchar2(10 byte)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10) char set latin casespecific	varchar(10)
varchar (sybase)	bytelen=8000encoding=UTF-8	varchar(8000) charset utf8mb4	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	clob	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000) charset utf8mb4	varchar(8000) charset utf8mb4	clob	clob	clob	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000)	varchar(8000) char set latin casespecific	varchar(8000)
varchar (sybase)	bytelen=40charlen=10encoding=UTF-8	varchar(10) charset utf8mb4	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(40)	varchar(10)	varchar(10)	varchar(10)	varchar(60)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(40)	varchar(10) charset utf8mb4	varchar(10) charset utf8mb4	varchar2(10 char)	varchar2(20 char)	varchar2(10 byte)	varchar(10)	varchar(10)	varchar(40)	varchar(10)	varchar(10)	varchar(10) char set latin casespecific	varchar(40)
varchar (sybase)	bytelen=10encoding=WINDOWS-1252	varchar(10) charset latin1	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(20)	varchar(10)	varchar(10)	varchar(10)	varchar(20)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(20)	varchar(10) charset latin1	varchar(10) charset latin1	varchar2(10 char)	varchar2(10 char)	varchar2(10 byte)	varchar(10)	varchar(10)	varchar(20)	varchar(10)	varchar(10)	varchar(10) char set latin casespecific	varchar(20)
varchar(max)	encoding=WINDOWS-1252	longtext charset latin1	text	text	text	varchar(max)	varchar(max)	clob(2147483647)	clob(2147483647)	clob(2147483647)	text	clob	string	string	string	string	string	long varchar	longtext charset latin1	longtext charset latin1	clob	clob	clob	text	text	varchar(65535)	varchar(max)	varchar(16777216)	clob(2097088000) char set latin	varchar(32000)
varchar2	bytelen=10encoding=UTF-8	varchar(10) charset utf8mb4	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(60)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10) charset utf8mb4	varchar(10) charset utf8mb4	varchar2(10 byte)	varchar2(20 char)	varchar2(10 byte)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10) char set latin casespecific	varchar(10)
varchar2	bytelen=40charlen=10encoding=UTF-8	varchar(10) charset utf8mb4	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(40)	varchar(10)	varchar(10)	varchar(10)	varchar(60)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(40)	varchar(10) charset utf8mb4	varchar(10) charset utf8mb4	varchar2(10 char)	varchar2(20 char)	varchar2(10 byte)	varchar(10)	varchar(10)	varchar(40)	varchar(10)	varchar(10)	varchar(10) char set latin casespecific	varchar(40)
varchar2	bytelen=10encoding=WINDOWS-1252	varchar(10) charset latin1	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(20)	varchar(10)	varchar(10)	varchar(10)	varchar(20)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(20)	varchar(10) charset latin1	varchar(10) charset latin1	varchar2(10 char)	varchar2(10 char)	varchar2(10 byte)	varchar(10)	varchar(10)	varchar(20)	varchar(10)	varchar(10)	varchar(10) char set latin casespecific	varchar(20)
vargraphic	charlen=10	varchar(10) charset utf8mb4	varchar(10)	varchar(10)	varchar(10)	nvarchar(10)	nvarchar(10)	vargraphic(10)	nvarchar(10)	vargraphic(10)	varchar(10)	nvarchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	varchar(10)	nvarchar(10)	varchar(10) charset utf8mb4	varchar(10) charset utf8mb4	nvarchar2(10)	nvarchar2(10)	nvarchar2(10)	varchar(10)	varchar(10)	varchar(40)	nvarchar(10)	varchar(10)	varchar(10) char set unicode casespecific	nvarchar(10)
xml		longtext charset utf8mb4	text	text	text	nvarchar(max)	xml	xml	dbclob(1073741823) CCSID 13488	xml	text	nclob	string	string	string	string	string	long nvarchar	longtext charset utf8mb4	longtext charset utf8mb4	nclob	nclob	nclob	text	text	varchar(65535)	xml	varchar(16777216)	clob(1048544000) char set unicode	nvarchar(16000)

Target Location Class