Data Type Mapping

From HVR
Jump to: navigation, search


This section describes HVR's mapping of data types from the source DBMS to the target DBMS or file format.

Background

HVR’s mapping 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’. This mapping happens at the moment when a channel is built using Table Explore or using the command hvradapt. After tables are added to a channel the mapping of data types in source DBMS to HVR’s catalog data types can be viewed in HVRGUI from the Table Explore dialog. Then during HVR Refresh and Integrate HVR maps its HVR catalog data types to corresponding data types in the target DBMS. This mapping happens at the moment the HVR Refresh is used to create target tables. When writing files in certain formats (Avro, JSON, and Parquet) the mapping of data types happen during HVR Refresh and Integrate. 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 dialog.

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 into numeric(38,4) in SQL Server. By defining the following action, Oracle’s number (without scale or precision) 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) into float.

Alternatively, ColumnProperties /Name can be used for mapping the data type in column "MYCOLUMN" into float.

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 with parameters /CaptureExpression and /IntegrateExpression for converting an extended data type to a supported data type during capture, compare or refresh (source) and back to extended data type during integrate, compare or refresh (target).

How to Map a Source Data Type to a Target Data Type

This section describes about how to use this documentation to find the mapping of data types from the source DBMS to the target DBMS or file format. The example here illustrates the data type mapping of timestamp with time zone in Oracle to the corresponding data type in Avro.
  1. Select the required DBMS tab from section Mapping of DBMS Data Types to HVR Catalog Data Types to view the mapping of DBMS data types to HVR catalog data types.
  2. For this example, select Oracle tab to find timestamp with time zone is mapped to HVR’s catalog data type timestamp with tz (oracle).
  3. Then in section Mapping of HVR Catalog Data Types to DBMS Data Types, select the required DBMS in Location Class Selector to view the mapping of HVR catalog data types to DBMS data types.
  4. For this example, select Avro 1.6 and Avro 1.8 in Location Class Selector. In the table displayed below Location Class Selector, you can find that timestamp with tz (oracle) (in column HVR Catalog Data Types) is mapped to varchar(100) in Avro 1.6 and timestamp-millis in Avro 1.8.

Mapping of DBMS Data Types to HVR Catalog Data Types

This section lists the mapping of DBMS data types to HVR's catalog data types.

Note: The version of the source location DBMS also affects how data types are mapped in HVR; the table below only corresponds to the latest DBMS versions.
Data Type HVR Capture Support Maps to 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 Maps to HVR Catalog Data Type
bigint Native bigint
decfloat Extended <<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 Extended <<xml>>
rowid Extended <<rowid>>
user defined Extended <<user defined>>
Data Type HVR Capture Support Maps to HVR Catalog Data Type
bigint Native bigint
decimal Native decimal
double Native float
float (<n>) Native float or real (if <n> is less than 25)
integer Native integer
real Native real
smalldecimal Native number
smallint Native smallint
tinyint Native tinyint
date Native ansidate
time Native time2
seconddate Native timstamp
timestamp Native timestamp
alphanum Native nvarchar
nvarchar Native nvarchar
shorttext Native nvarchar
varchar Native varchar
binary Native binary
varbinary Native varbinary
boolean Native boolean
bintext Native blob
blob Native blob
clob Native clob
nclob Native nclob
text Native nclob
array Extended <<array>>
st_geometry Extended <<st_geometry>>
st_point Extended <<st_point>>
Data Type HVR Capture Support Maps to 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 Maps to 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 Maps to 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 Maps to 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 Maps to 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 Maps to 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>>


Mapping of HVR Catalog Data Types to DBMS Data Types

This section lists the mapping of HVR's catalog data types to DBMS data types.

Note:
  1. The version of the target location DBMS also affects how HVR maps data types; It does not map to data types which are not supported by an older version of DBMS in target location. For simplicity, this is not reflected in the documentation here; the table below only corresponds to the latest supported DBMS versions.
  2. For data type Attributes (e.g, charlen, bytelen, scale, precision etc.) every feasible combination of values is possible. However, this table contains only enough combinations to illustrate the effect of variation.


Location Class Selector 
Legend
Cells marked green indicates the data types with ‘reversible mapping’. If an HVR catalog data type is mapped to a DBMS data type and HVR maps that DBMS data type back to the same catalog type, this mapping is called reversible. For example, if HVR’s Table Explore encounters clob in Oracle it will populate its HVR catalog data type as clob and if HVR has clob in its catalogs (during HVR Refresh/Integrate) then it will create that column as clob in Oracle.
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 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 long date date date date date date date date date date date date ansidate with null[native] date date date date date date date date date date date ansidate with null[native]
ansidate   date[native] date long date date[native] date[native] date[native] date[native] date date[native] date[native] date[native] date[native] date[native] date[native] ansidate with null date[native] date[native] date date date date date date date[native] date[native] date[native] ansidate with null
bfile   longblob bytea bytes bytes varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte with null longblob longblob bfile[native] bfile[native] bfile[native] blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000) with null
bigint unsigned bytelen=8 bigint unsigned[native] numeric(20) double 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) with null bigint unsigned[native] bigint unsigned[native] number(20) number(20) number(20) decimal(20) numeric(20) decimal(20) numeric(20) number(38) decimal(20) decimal(20) with null
bigint bytelen=8 bigint[native] bigint[native] long long bigint[native] bigint[native] bigint[native] bigint[native] bigint[native] bigint[native] bigint[native] bigint[native] bigint[native] bigint[native] bigint[native] bigint with null[native] bigint[native] bigint[native] number(19) number(19) number(19) bigint[native] bigint[native] bigint[native] bigint[native] number(38) bigint[native] bigint with null[native]
binary bytelen=10 binary(10)[native] bytea bytes bytes binary(10)[native] binary(10)[native] char(10) for bit data[native] binary(10)[native] bytea binary(10)[native] binary binary binary char(2) binary byte(10) with null[native] binary(10)[native] binary(10)[native] raw(10) raw(10) raw(10) blob bytea char(10) binary(10)[native] binary(10) byte(10)[native] char(10) with null
binary_double bytelen=8 double float double double float float double double float double double double double double double float with null double double binary_double[native] binary_double[native] binary_double[native] float float float float float float float with null
binary_float bytelen=4 float real float float real real real real real real float float float float float float4 with null float float binary_float[native] binary_float[native] binary_float[native] real real real real float float float4 with null
bit (mysql) bitlen=32 bit(32)[native] 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) with null bit(32)[native] bit(32)[native] 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) with null
bit   tinyint boolean boolean boolean bit[native] bit[native] smallint smallint boolean boolean boolean boolean boolean boolean boolean boolean with null tinyint tinyint number(1) number(1) number(1) boolean boolean boolean bit[native] boolean byteint boolean with null
blob   longblob bytea[native] bytes bytes varbinary(max) varbinary(max) blob(2147483647)[native] blob(2147483647)[native] bytea[native] blob[native] binary[native] binary[native] binary[native] string binary[native] long byte with null[native] longblob longblob blob[native] blob[native] blob[native] blob[native] bytea[native] varchar(65535) varbinary(max) binary(8388608)[native] blob(2097088000)[native] varchar(32000) with null
boolean   tinyint boolean[native] boolean[native] boolean[native] bit[native] bit[native] smallint smallint boolean[native] boolean[native] boolean[native] boolean[native] boolean[native] boolean[native] boolean[native] boolean with null[native] tinyint tinyint number(1) number(1) number(1) boolean[native] boolean[native] boolean[native] bit[native] boolean[native] byteint boolean with null[native]
byte varying bytelen=10 varbinary(10) bytea bytes bytes varbinary(10) varbinary(10) varchar(10) for bit data varbinary(10) bytea varbinary(10) binary binary binary string binary byte varying(10) with null[native] varbinary(10) varbinary(10) raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10) binary(10) varbyte(10) varchar(10) with null
byte bytelen=10 binary(10) bytea bytes bytes binary(10) binary(10) char(10) for bit data binary(10) bytea binary(10) binary binary binary char(2) binary byte(10) with null[native] binary(10) binary(10) raw(10) raw(10) raw(10) blob bytea char(10) binary(10) binary(10) byte(10)[native] char(10) with null
byteint bytelen=1 tinyint smallint int int smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint i1 with null tinyint tinyint number(3) number(3) number(3) smallint smallint smallint smallint number(38) byteint[native] i1 with null
c bytelen=10
encoding=UTF-8
char(10) charset utf8mb4 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 with null[native] 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 with null[native]
char bytelen=10
encoding=UTF-8
char(10) charset utf8mb4 char(10) char(10) char(10) char(10) char(10) char(10)[native] char(10)[native] char(10) char(60) char(10) char(10) char(10) char(10) char(10) char(10) with null[native] char(10) charset utf8mb4 char(10) charset utf8mb4 char(10 byte) char(20 char) char(10 byte) char(10) char(10) char(10)[native] char(10) varchar(10) char(10) char set latin casespecific char(10) with null[native]
char bytelen=4000
encoding=UTF-8
varchar(4000) charset utf8mb4 char(4000) char(4000) char(4000) char(4000) char(4000) varchar(4000) char(4000)[native] char(4000) clob varchar(4000) varchar(4000) varchar(4000) varchar(4000) varchar(4000) char(4000) with null[native] varchar(4000) charset utf8mb4 varchar(4000) charset utf8mb4 varchar2(4000 byte) clob varchar2(4000 byte) char(4000) char(4000) char(4000)[native] char(4000) varchar(4000) char(4000) char set latin casespecific char(4000) with null[native]
char bytelen=8000
encoding=UTF-8
varchar(8000) charset utf8mb4 char(8000) char(8000) char(8000) char(8000) char(8000) varchar(8000) char(8000)[native] char(8000) clob varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) char(8000) with null[native] 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) with null[native]
char bytelen=40
charlen=10
encoding=UTF-8
char(10) charset utf8mb4[native] char(10)[native] char(10)[native] char(10)[native] char(10) char(10) char(40)[native] char(10)[native] char(10)[native] char(60) char(10)[native] char(10)[native] char(10)[native] char(10)[native] char(10)[native] char(40) with null[native] char(10) charset utf8mb4[native] char(10) charset utf8mb4[native] char(10 char) char(20 char) char(10 byte) char(10)[native] char(10)[native] char(40)[native] char(10) varchar(10) char(10) char set latin casespecific char(40) with null[native]
char bytelen=10
encoding=WINDOWS-1252
char(10) charset latin1[native] char(10) char(10) char(10) char(10)[native] char(10)[native] char(20) char(10)[native] char(10) char(20) char(10) char(10) char(10) char(10) char(10) char(20) with null char(10) charset latin1[native] char(10) charset latin1[native] char(10 char) char(10 char) char(10 byte) char(10) char(10) char(20) char(10)[native] varchar(10) char(10) char set latin casespecific char(20) with null
char (oracle) bytelen=10
encoding=UTF-8
char(10) charset utf8mb4 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) with null char(10) charset utf8mb4 char(10) charset utf8mb4 char(10 byte)[native] char(20 char) char(10 byte) char(10) char(10) char(10) char(10) varchar(10) char(10) char set latin casespecific char(10) with null
char (oracle) bytelen=2000
encoding=UTF-8
varchar(2000) charset utf8mb4 char(2000) char(2000) char(2000) char(2000) char(2000) varchar(2000) char(2000) char(2000) clob varchar(2000) varchar(2000) varchar(2000) varchar(2000) varchar(2000) char(2000) with null varchar(2000) charset utf8mb4 varchar(2000) charset utf8mb4 char(2000 byte)[native] clob char(2000 byte) char(2000) char(2000) char(2000) char(2000) varchar(2000) char(2000) char set latin casespecific char(2000) with null
char (oracle) bytelen=40
charlen=10
encoding=UTF-8
char(10) charset utf8mb4 char(10) char(10) char(10) char(10) char(10) char(40) char(10) char(10) char(60) char(10) char(10) char(10) char(10) char(10) char(40) with null char(10) charset utf8mb4 char(10) charset utf8mb4 char(10 char)[native] char(20 char) char(10 byte) char(10) char(10) char(40) char(10) varchar(10) char(10) char set latin casespecific char(40) with null
char (oracle) bytelen=10
encoding=WINDOWS-1252
char(10) charset latin1 char(10) char(10) char(10) char(10) char(10) char(20) char(10) char(10) char(20) char(10) char(10) char(10) char(10) char(10) char(20) with null char(10) charset latin1 char(10) charset latin1 char(10 char) char(10 char) char(10 byte)[native] char(10) char(10) char(20) char(10) varchar(10) char(10) char set latin casespecific char(20) with null
clob encoding=UTF-8 longtext charset utf8mb4 text[native] string string varchar(max) varchar(max) clob(2147483647)[native] clob(2147483647)[native] text[native] clob string[native] string[native] string[native] string[native] string[native] long varchar with null[native] longtext charset utf8mb4 longtext charset utf8mb4 clob[native] clob clob text[native] text[native] varchar(65535)[native] varchar(max) varchar(16777216)[native] clob(2097088000) char set latin varchar(32000) with null
date   datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp ingresdate with null datetime(0) datetime(0) date[native] date[native] date[native] timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with null
datetime (mysql) prec_sec=0 datetime(0)[native] timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone with null datetime(0)[native] datetime(0)[native] timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with null
datetime   datetime(3) timestamp(3) varchar(100) timestamp-millis datetime[native] datetime[native] timestamp(3) timestamp timestamp(3) timestamp timestamp timestamp timestamp timestamp timestamp ingresdate with null datetime(3) datetime(3) timestamp(6) timestamp(6) timestamp(6) timestamp-millis timestamp(3) timestamp datetime[native] timestamp_ntz(3) timestamp(3) ansidate with null
datetime2 prec_sec=0 datetime(0)[native] timestamp(0) varchar(100) timestamp-millis datetime2(0)[native] datetime2(0)[native] timestamp(0)[native] timestamp timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone with null datetime(0)[native] datetime(0)[native] timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0)[native] timestamp_ntz(0)[native] timestamp(0)[native] timestamp(0) with null
datetimeoffset   datetime(0) timestamp(0) with time zone varchar(100) timestamp-millis datetimeoffset(0)[native] datetimeoffset(0)[native] timestamp(0) timestamp timestamp(0) with time zone timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with time zone with null 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)[native] timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone with null
dbclob   longtext charset utf8mb4 text string string nvarchar(max) nvarchar(max) dbclob(1073741823)[native] dbclob(1073741823) CCSID 13488[native] text nclob string string string string string long nvarchar with null longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode nvarchar(16000) with null
decimal prec=10
scale=3
decimal(10,3)[native] numeric(10,3)[native] varchar(12) decimal(10,3)[native] numeric(10,3) numeric(10,3) decimal(10,3)[native] decimal(10,3)[native] decimal(10,3)[native] decimal(10,3)[native] decimal(10,3)[native] decimal(10,3)[native] decimal(10,3)[native] decimal(10,3)[native] decimal(10,3)[native] decimal(10,3) with null[native] decimal(10,3)[native] decimal(10,3)[native] number(10,3) number(10,3) number(10,3) decimal(10,3)[native] numeric(10,3)[native] decimal(10,3)[native] numeric(10,3) number(10,3)[native] decimal(10,3)[native] decimal(10,3) with null[native]
decimal prec=6 decimal(6)[native] numeric(6)[native] varchar(8) decimal(6)[native] numeric(6) numeric(6) decimal(6)[native] decimal(6)[native] decimal(6)[native] decimal(6)[native] decimal(6)[native] decimal(6)[native] decimal(6)[native] decimal(6)[native] decimal(6)[native] decimal(6) with null[native] decimal(6)[native] decimal(6)[native] number(6) number(6) number(6) decimal(6)[native] numeric(6)[native] decimal(6)[native] numeric(6) number(6)[native] decimal(6)[native] decimal(6) with null[native]
double bytelen=8 double[native] float double[native] double[native] float float double[native] double[native] float double[native] double[native] double[native] double[native] double[native] double[native] float with null double[native] double[native] binary_double binary_double binary_double float float float float float float float with null
epoch   timestamp(0)null[native] timestamp(0) long timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) with local time zone with null timestamp(0)null[native] timestamp(0)null[native] timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with local time zone with null
float bytelen=8 double[native] float[native] double double float[native] float[native] double[native] double[native] float[native] double[native] double[native] double[native] double[native] double[native] double[native] float with null[native] double[native] double[native] binary_double[native] binary_double[native] binary_double[native] float[native] float[native] float[native] float[native] float[native] float[native] float with null[native]
float4 bytelen=4 float real float float real real real real real real float float float float float float4 with null[native] float float binary_float binary_float binary_float real real real real float float float4 with null[native]
float8 bytelen=8 double float double double float float double double float double double double double double double float with null double double binary_double binary_double binary_double float float float float float float float with null
graphic charlen=10 char(10) charset utf8mb4 char(10) char(10) char(10) nchar(10) nchar(10) graphic(10)[native] nchar(10) char(10) nchar(10) char(10) char(10) char(10) char(10) char(10) nchar(10) with null 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) with null
image   longblob bytea bytes bytes varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte with null longblob longblob blob blob blob blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000) with null
ingresdate   datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp ingresdate with null[native] datetime(0) datetime(0) date date date timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with null
int unsigned bytelen=4 int unsigned[native] bigint long long bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint with null int unsigned[native] int unsigned[native] number(10) number(10) number(10) bigint bigint bigint bigint number(38) bigint bigint with null
int bytelen=4 int[native] integer[native] int[native] int[native] int[native] int[native] integer[native] integer[native] integer[native] integer[native] int[native] int[native] int[native] int[native] int[native] integer with null[native] int[native] int[native] number(10) number(10) number(10) integer[native] integer[native] integer[native] int[native] number(38) integer[native] integer with null[native]
integer bytelen=4 int[native] integer[native] int int int[native] int[native] integer[native] integer[native] integer[native] integer[native] int[native] int[native] int[native] int[native] int[native] integer with null[native] int[native] int[native] number(10) number(10) number(10) integer[native] integer[native] integer[native] int[native] number(38) integer[native] integer with null[native]
integer1 bytelen=1 tinyint smallint int int smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint i1 with null tinyint tinyint number(3) number(3) number(3) smallint smallint smallint smallint number(38) byteint i1 with null
integer2 bytelen=2 smallint smallint int int smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint with null smallint smallint number(5) number(5) number(5) smallint smallint smallint smallint number(38) smallint smallint with null
integer4 bytelen=4 int integer int int int int integer integer integer integer int int int int int integer with null int int number(10) number(10) number(10) integer integer integer int number(38) integer integer with null
integer8 bytelen=8 bigint bigint long long bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint with null bigint bigint number(19) number(19) number(19) bigint bigint bigint bigint number(38) bigint bigint with null
interval day to second (ingres)   datetime(0) timestamp(0) varchar(100) duration datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) interval day to second(0) with null[native] 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) with null[native]
interval day to second   datetime(0) timestamp(0) varchar(100) duration datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) interval day to second(0) with null datetime(0) datetime(0) interval day(0) to second(0)[native] interval day(0) to second(0)[native] interval day(0) to second(0)[native] interval month to second timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) interval day to second(0) with null
interval month to second   datetime(6) timestamp(6) varchar(100) duration datetime2(7) datetime2(7) timestamp(12) timestamp timestamp(6) timestamp varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) interval day to second(0) with null datetime(6) datetime(6) interval day(9) to second(0) interval day(9) to second(0) interval day(9) to second(0) interval month to second[native] timestamp(6) timestamp datetime2(7) timestamp_ntz(9) timestamp(6) interval day to second(0) with null
interval year to month (ingres)   datetime(0) timestamp(6) varchar(100) duration datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(6) timestamp varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) interval year to month with null[native] 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 with null[native]
interval year to month   datetime(0) timestamp(6) varchar(100) duration datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(6) timestamp varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) interval year to month with null datetime(0) datetime(0) interval year(0) to month[native] interval year(0) to month[native] interval year(0) to month[native] interval month to second timestamp(6) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) interval year to month with null
json   longtext charset utf8mb4 json[native] string string varchar(max) varchar(max) clob(2147483647) clob(2147483647) text clob string string string string string long varchar with null longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text json[native] varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
jsonb   longtext charset utf8mb4 jsonb[native] string string varchar(max) varchar(max) clob(2147483647) clob(2147483647) text clob string string string string string long varchar with null longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text jsonb[native] varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
long byte   longblob bytea bytes bytes varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte with null[native] longblob longblob blob blob blob blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000) with null
long char encoding=UTF-8 longtext charset utf8mb4 char[native] string string varchar(max) varchar(max) clob(2147483647) clob(2147483647) char[native] clob string string string string string long varchar with null longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text char[native] varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
long nvarchar (db2)   longtext charset utf8mb4 text string string nvarchar(max) nvarchar(max) long vargraphic[native] dbclob(1073741823) CCSID 13488 text nclob string string string string string long nvarchar with null longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode nvarchar(16000) with null
long nvarchar   longtext charset utf8mb4 text string string nvarchar(max) nvarchar(max) dbclob(1073741823) dbclob(1073741823) CCSID 13488 text nclob string string string string string long nvarchar with null[native] longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode nvarchar(16000) with null
long raw   longblob bytea bytes bytes varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte with null longblob longblob long raw[native] long raw[native] long raw[native] blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000) with null
long varbinary   longblob bytea bytes bytes varbinary(max) varbinary(max) long varchar for bit data[native] blob(2147483647) bytea blob binary binary binary string binary long byte with null longblob longblob blob blob blob blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000) with null
long varchar (db2) encoding=UTF-8 longtext charset utf8mb4 text string string varchar(max) varchar(max) long varchar[native] clob(2147483647) text clob string string string string string long varchar with null longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
long varchar encoding=UTF-8 longtext charset utf8mb4 text string string varchar(max) varchar(max) clob(2147483647) clob(2147483647) text clob string string string string string long varchar with null[native] longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
long encoding=UTF-8 longtext charset utf8mb4 text string string varchar(max) varchar(max) clob(2147483647) clob(2147483647) text clob string string string string string long varchar with null longtext charset utf8mb4 longtext charset utf8mb4 long[native] long long text text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
mediumint unsigned bytelen=3 mediumint unsigned[native] integer int int int int integer integer integer integer int int int int int integer with null mediumint unsigned[native] mediumint unsigned[native] number(8) number(8) number(8) integer integer integer int number(38) integer integer with null
mediumint bytelen=3 mediumint[native] integer int int int int integer integer integer integer int int int int int integer with null mediumint[native] mediumint[native] number number number integer integer integer int number(38) integer integer with null
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) money with null[native] 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 with null[native]
money   decimal(19,4) numeric(19,4) varchar(21) decimal(19,4) money[native] money[native] 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 with null 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[native] number(19,4) decimal(19,4) money with null
nchar charlen=10 char(10) charset utf8mb4 char(10) char(10) char(10) nchar(10)[native] nchar(10)[native] graphic(10)[native] nchar(10)[native] char(10) nchar(10)[native] char(10) char(10) char(10) char(10) char(10) nchar(10) with null[native] char(10) charset utf8mb4 char(10) charset utf8mb4 nchar(10) nchar(10) nchar(10) char(10) char(10) varchar(40) nchar(10)[native] varchar(10) char(10) char set unicode casespecific[native] nchar(10) with null[native]
nchar (oracle) charlen=10 char(10) charset utf8mb4 char(10) char(10) char(10) nchar(10) nchar(10) graphic(10) nchar(10) char(10) nchar(10) char(10) char(10) char(10) char(10) char(10) nchar(10) with null char(10) charset utf8mb4 char(10) charset utf8mb4 nchar(10)[native] nchar(10)[native] nchar(10)[native] char(10) char(10) varchar(40) nchar(10) varchar(10) char(10) char set unicode casespecific nchar(10) with null
nclob   longtext charset utf8mb4 text string string nvarchar(max) nvarchar(max) dbclob(1073741823)[native] dbclob(1073741823) CCSID 13488[native] text nclob[native] string string string string string long nvarchar with null[native] longtext charset utf8mb4 longtext charset utf8mb4 nclob[native] nclob[native] nclob[native] text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode[native] nvarchar(16000) with null
ntext   longtext charset utf8mb4 text string string nvarchar(max) nvarchar(max) dbclob(1073741823) dbclob(1073741823) CCSID 13488 text nclob string string string string string long nvarchar with null longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode nvarchar(16000) with null
number   decimal(65,4) numeric[native] double decimal(1000,4) numeric(38,4) numeric(38,4) decimal(31,4) decimal(63,4) numeric[native] decimal[native] decimal(38,4) decimal(38,4) decimal(38,4) decimal(38,4) decimal(38,4) decimal(39,4) with null decimal(65,4) decimal(65,4) number[native] number[native] number[native] decimal(1000,4) numeric[native] decimal(38,4) numeric(38,4) number(38,4) number[native] decimal(38,4) with null
number prec=10
scale=-127
double float double double float float double double float double double double double double double float with null double double float(10)[native] float(10)[native] float(10)[native] float float float float float float float with null
number prec=10
scale=3
decimal(10,3) numeric(10,3) double 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) with null decimal(10,3) decimal(10,3) number(10,3)[native] number(10,3)[native] number(10,3)[native] decimal(10,3) numeric(10,3) decimal(10,3) numeric(10,3) number(10,3) number(10,3)[native] decimal(10,3) with null
number prec=26 decimal(26) numeric(26) double 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) with null decimal(26) decimal(26) number(26)[native] number(26)[native] number(26)[native] decimal(26) numeric(26) decimal(26) numeric(26) number(26) number(26)[native] decimal(26) with null
number prec=6 int numeric(6) int int int int integer integer decimal(6) decimal(6) int int int int int integer with null int int number(6)[native] number(6)[native] number(6)[native] integer numeric(6) integer int number(6) number(6)[native] integer with null
numeric (db2i) prec=10
scale=3
decimal(10,3) numeric(10,3) varchar(12) decimal(10,3) numeric(10,3) numeric(10,3) decimal(10,3) numeric(10,3)[native] decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) with null 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) with null
numeric (db2i) prec=6 decimal(6) numeric(6) varchar(8) decimal(6) numeric(6) numeric(6) decimal(6) numeric(6)[native] decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) with null decimal(6) decimal(6) number(6) number(6) number(6) decimal(6) numeric(6) decimal(6) numeric(6) number(6) decimal(6) decimal(6) with null
numeric prec=10
scale=3
decimal(10,3) numeric(10,3) varchar(12) decimal(10,3) numeric(10,3)[native] numeric(10,3)[native] 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) with null 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)[native] number(10,3) decimal(10,3) decimal(10,3) with null
numeric prec=26 decimal(26) numeric(26) varchar(28) decimal(26) numeric(26)[native] numeric(26)[native] decimal(26) numeric(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) with null decimal(26) decimal(26) number(26) number(26) number(26) decimal(26) numeric(26) decimal(26) numeric(26)[native] number(26) decimal(26) decimal(26) with null
numeric prec=6 decimal(6) numeric(6) varchar(8) decimal(6) numeric(6)[native] numeric(6)[native] decimal(6) numeric(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) with null decimal(6) decimal(6) number(6) number(6) number(6) decimal(6) numeric(6) decimal(6) numeric(6)[native] number(6) decimal(6) decimal(6) with null
nvarchar charlen=10 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) nvarchar(10)[native] nvarchar(10)[native] vargraphic(10)[native] nvarchar(10)[native] varchar(10) nvarchar(10)[native] varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) nvarchar(10) with null[native] varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 nvarchar2(10) nvarchar2(10) nvarchar2(10) varchar(10) varchar(10) varchar(40) nvarchar(10)[native] varchar(10) varchar(10) char set unicode casespecific[native] nvarchar(10) with null[native]
nvarchar(max)   longtext charset utf8mb4 text string string nvarchar(max)[native] nvarchar(max)[native] dbclob(1073741823) dbclob(1073741823) CCSID 13488 text nclob string string string string string long nvarchar with null longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max)[native] varchar(16777216) clob(1048544000) char set unicode nvarchar(16000) with null
nvarchar2 charlen=10 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) nvarchar(10) nvarchar(10) vargraphic(10) nvarchar(10) varchar(10) nvarchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) nvarchar(10) with null varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 nvarchar2(10)[native] nvarchar2(10)[native] nvarchar2(10)[native] varchar(10) varchar(10) varchar(40) nvarchar(10) varchar(10) varchar(10) char set unicode casespecific nvarchar(10) with null
postgres date   date date[native] long date date date date date date[native] date date date date date date ansidate with null date date date date date date date[native] date[native] date date date ansidate with null
postgres timestamp with time zone   datetime(0) timestamp(0) with time zone[native] varchar(100) timestamp-millis datetimeoffset(0) datetimeoffset(0) timestamp(0) timestamp timestamp(0) with time zone[native] timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with time zone with null 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[native] timestamp datetimeoffset(0) timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone with null
postgres timestamp   datetime(0) timestamp(0)[native] varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0)[native] timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone with null datetime(0) datetime(0) timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0)[native] timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with null
raw bytelen=10 varbinary(10) bytea bytes bytes varbinary(10) varbinary(10) varchar(10) for bit data varbinary(10) bytea varbinary(10) binary binary binary string binary byte varying(10) with null varbinary(10) varbinary(10) raw(10)[native] raw(10)[native] raw(10)[native] blob bytea varchar(10) varbinary(10) binary(10) varbyte(10) varchar(10) with null
real bytelen=4 float real[native] float float real[native] real[native] real[native] real[native] real[native] real[native] float float float float float float4 with null float float binary_float binary_float binary_float real[native] real[native] real[native] real[native] float float float4 with null
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) with null char(18) charset ascii char(18) charset ascii rowid[native] rowid[native] rowid[native] char(18) char(18) char(18) char(18) varchar(18) char(18) char set latin casespecific char(18) with null
rowversion bytelen=10 binary(10) bytea bytes bytes binary(10) binary(10) char(10) for bit data binary(10) bytea binary(10) binary binary binary char(2) binary byte(10) with null binary(10) binary(10) raw(10) raw(10) raw(10) blob bytea char(10) binary(10) binary(10) byte(10) char(10) with null
smalldatetime   datetime(0) timestamp(0) varchar(100) timestamp-millis smalldatetime[native] smalldatetime[native] timestamp(0) timestamp timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp ingresdate with null datetime(0) datetime(0) date date date timestamp-millis timestamp(0) timestamp smalldatetime[native] timestamp_ntz(0) timestamp(0) ansidate with null
smallint unsigned bytelen=2 smallint unsigned[native] integer int int int int integer integer integer integer int int int int int integer with null smallint unsigned[native] smallint unsigned[native] number(5) number(5) number(5) integer integer integer int number(38) integer integer with null
smallint bytelen=2 smallint[native] smallint[native] int int smallint[native] smallint[native] smallint[native] smallint[native] smallint[native] smallint[native] smallint[native] smallint[native] smallint[native] smallint[native] smallint[native] smallint with null[native] smallint[native] smallint[native] number(5) number(5) number(5) smallint[native] smallint[native] smallint[native] smallint[native] number(38) smallint[native] smallint with null[native]
smallmoney   decimal(10,4) numeric(10,4) varchar(12) decimal(10,4) smallmoney[native] smallmoney[native] 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) with null 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[native] number(10,4) decimal(10,4) decimal(10,4) with null
text (ingres) bytelen=10
encoding=UTF-8
varchar(10) charset utf8mb4 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) with null[native] 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) with null[native]
text (sqlserver) encoding=WINDOWS-1252 longtext charset latin1 text string string varchar(max) varchar(max) clob(2147483647) clob(2147483647) text clob string string string string string long varchar with null longtext charset latin1 longtext charset latin1 clob clob clob text text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
time (mysql) prec_sec=0 time(0)[native] time(0) int time-millis time(0) time(0) time time time(0) time varchar(20) varchar(20) varchar(20) varchar(20) varchar(20) time(0) without time zone with null time(0)[native] time(0)[native] timestamp(0) timestamp(0) timestamp(0) time(3) time(0) timestamp time(0) time(0) time(0) time(0) without time zone with null
time with local time zone   time(0) time(0) int time-millis time(0) time(0) time time time(0) time varchar(20) varchar(20) varchar(20) varchar(20) varchar(20) time(0) with local time zone with null[native] 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 with null[native]
time with time zone   time(0) time(0) with time zone[native] int time-millis time(0) time(0) time time time(0) time varchar(20) varchar(20) varchar(20) varchar(20) varchar(20) time(0) with time zone with null[native] 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[native] timestamp time(0) time(0) time(0) with time zone[native] time(0) with time zone with null[native]
time prec_sec=0 time(0) time(0)[native] int time-millis time(0)[native] time(0)[native] time time time(0)[native] time varchar(20) varchar(20) varchar(20) varchar(20) varchar(20) time(0) without time zone with null[native] time(0) time(0) timestamp(0) timestamp(0) timestamp(0) time(3) time(0)[native] timestamp time(0)[native] time(0)[native] time(0)[native] time(0) without time zone with null[native]
time prec_sec=3 time(3) time(3)[native] int time-millis time(3)[native] time(3)[native] time time time(3)[native] time varchar(20) varchar(20) varchar(20) varchar(20) varchar(20) time(3) without time zone with null[native] time(3) time(3) timestamp(3) timestamp(3) timestamp(3) time(3)[native] time(3)[native] timestamp time(3)[native] time(3)[native] time(3)[native] time(3) without time zone with null[native]
time2   time(6) time(0) int time-millis time(0) time(0) time[native] time[native] time(0) time[native] varchar(20) varchar(20) varchar(20) varchar(20) varchar(20) time(0) without time zone with null 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 with null
timestamp (db2) prec_sec=0 datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0)[native] timestamp timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone with null datetime(0) datetime(0) timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with null
timestamp (ingres)   datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone with null[native] datetime(0) datetime(0) timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with null[native]
timestamp (mysql)   timestamp(0)null[native] timestamp(0) long timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) with local time zone with null timestamp(0)null[native] timestamp(0)null[native] timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with local time zone with null
timestamp (oracle)   datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone with null datetime(0) datetime(0) timestamp(0)[native] timestamp(0)[native] timestamp(0)[native] timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with null
timestamp (sqlserver) bytelen=10 binary(10) bytea bytes bytes binary(10)[native] binary(10)[native] char(10) for bit data binary(10) bytea binary(10) binary binary binary char(2) binary byte(10) with null binary(10) binary(10) raw(10) raw(10) raw(10) blob bytea char(10) binary(10)[native] binary(10) byte(10) char(10) with null
timestamp with local time zone   datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with local time zone with null[native] 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)[native] timestamp(0) timestamp(0) with local time zone with null[native]
timestamp with local tz (oracle)   datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with local time zone with null datetime(0) datetime(0) timestamp(0) with local time zone[native] timestamp(0) with local time zone[native] timestamp(0) with local time zone[native] timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ltz(0) timestamp(0) timestamp(0) with local time zone with null
timestamp with time zone   datetime(0) timestamp(0) with time zone varchar(100) timestamp-millis datetimeoffset(0)[native] datetimeoffset(0)[native] timestamp(0) timestamp timestamp(0) with time zone timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with time zone with null[native] 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)[native] timestamp_tz(0)[native] timestamp(0) with time zone[native] timestamp(0) with time zone with null[native]
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 timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with time zone with null datetime(0) datetime(0) timestamp(0) with time zone[native] timestamp(0) with time zone[native] timestamp(0) with time zone[native] timestamp-millis timestamp(0) with time zone timestamp datetimeoffset(0) timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone with null
timestamp prec_sec=0 datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0)[native] timestamp timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone with null datetime(0) datetime(0) timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0)[native] timestamp(0)[native] timestamp(0) with null
tinyint signed bytelen=1 tinyint smallint int int smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint i1 with null tinyint tinyint number(3) number(3) number(3) smallint smallint smallint smallint number(38) byteint i1 with null
tinyint unsigned bytelen=1 tinyint unsigned[native] smallint int int tinyint tinyint smallint smallint smallint tinyint smallint smallint smallint smallint smallint smallint with null tinyint unsigned[native] tinyint unsigned[native] number(3) number(3) number(3) smallint smallint smallint tinyint number(38) smallint smallint with null
tinyint bytelen=1 tinyint unsigned[native] smallint int int tinyint[native] tinyint[native] smallint smallint smallint tinyint[native] smallint smallint smallint smallint smallint smallint with null tinyint unsigned[native] tinyint unsigned[native] number(3) number(3) number(3) smallint smallint smallint tinyint[native] number(38) smallint smallint with null
uniqueidentifier   binary(16) char(36) char(36) char(36) uniqueidentifier[native] uniqueidentifier[native] char(16) for bit data binary(16) char(36) binary(16) char(36) char(36) char(36) char(36) char(36) byte(16) with null binary(16) binary(16) raw(16) raw(16) raw(16) char(36) char(36) char(36) uniqueidentifier[native] binary(16) byte(16) char(36) with null
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) with null varchar(100) charset ascii varchar(100) charset ascii urowid(75)[native] urowid(75)[native] urowid(75)[native] varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) char set latin casespecific varchar(100) with null
varbinary bytelen=10 varbinary(10)[native] bytea bytes bytes varbinary(10)[native] varbinary(10)[native] varchar(10) for bit data[native] varbinary(10)[native] bytea varbinary(10)[native] binary binary binary string binary byte varying(10) with null[native] varbinary(10)[native] varbinary(10)[native] raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10)[native] binary(10)[native] varbyte(10)[native] varchar(10) with null
varbinary(max)   longblob[native] bytea bytes bytes varbinary(max)[native] varbinary(max)[native] blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte with null longblob[native] longblob[native] blob blob blob blob bytea varchar(65535) varbinary(max)[native] binary(8388608) blob(2097088000) varchar(32000) with null
varbyte bytelen=10 varbinary(10) bytea bytes bytes varbinary(10) varbinary(10) varchar(10) for bit data varbinary(10) bytea varbinary(10) binary binary binary string binary byte varying(10) with null varbinary(10) varbinary(10) raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10) binary(10) varbyte(10)[native] varchar(10) with null
varchar bytelen=10
encoding=UTF-8
varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10)[native] varchar(10)[native] varchar(10) varchar(60) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) with null[native] varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 varchar2(10 byte) varchar2(20 char) varchar2(10 byte) varchar(10) varchar(10) varchar(10)[native] varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(10) with null[native]
varchar bytelen=8000
encoding=UTF-8
varchar(8000) charset utf8mb4 varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000)[native] varchar(8000)[native] varchar(8000) clob varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) with null[native] varchar(8000) charset utf8mb4 varchar(8000) charset utf8mb4 clob clob clob varchar(8000) varchar(8000) varchar(8000)[native] varchar(8000) varchar(8000) varchar(8000) char set latin casespecific varchar(8000) with null[native]
varchar bytelen=40
charlen=10
encoding=UTF-8
varchar(10) charset utf8mb4[native] varchar(10)[native] varchar(10)[native] varchar(10)[native] varchar(10) varchar(10) varchar(40)[native] varchar(10)[native] varchar(10)[native] varchar(60) varchar(10)[native] varchar(10)[native] varchar(10)[native] varchar(10)[native] varchar(10)[native] varchar(40) with null[native] varchar(10) charset utf8mb4[native] varchar(10) charset utf8mb4[native] varchar2(10 char) varchar2(20 char) varchar2(10 byte) varchar(10)[native] varchar(10)[native] varchar(40)[native] varchar(10) varchar(10)[native] varchar(10) char set latin casespecific varchar(40) with null[native]
varchar bytelen=10
encoding=WINDOWS-1252
varchar(10) charset latin1[native] varchar(10) varchar(10) varchar(10) varchar(10)[native] varchar(10)[native] varchar(20) varchar(10)[native] varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(20) with null varchar(10) charset latin1[native] varchar(10) charset latin1[native] varchar2(10 char) varchar2(10 char) varchar2(10 byte) varchar(10) varchar(10) varchar(20) varchar(10)[native] varchar(10) varchar(10) char set latin casespecific varchar(20) with null
varchar(max) encoding=WINDOWS-1252 longtext charset latin1[native] text string string varchar(max)[native] varchar(max)[native] clob(2147483647) clob(2147483647) text clob string string string string string long varchar with null longtext charset latin1[native] longtext charset latin1[native] clob clob clob text text varchar(65535) varchar(max)[native] varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
varchar2 bytelen=10
encoding=UTF-8
varchar(10) charset utf8mb4 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) with null varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 varchar2(10 byte)[native] varchar2(20 char) varchar2(10 byte) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(10) with null
varchar2 bytelen=40
charlen=10
encoding=UTF-8
varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(40) varchar(10) varchar(10) varchar(60) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(40) with null varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 varchar2(10 char)[native] varchar2(20 char) varchar2(10 byte) varchar(10) varchar(10) varchar(40) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(40) with null
varchar2 bytelen=10
encoding=WINDOWS-1252
varchar(10) charset latin1 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(20) with null varchar(10) charset latin1 varchar(10) charset latin1 varchar2(10 char) varchar2(10 char) varchar2(10 byte)[native] varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(20) with null
vargraphic charlen=10 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) nvarchar(10) nvarchar(10) vargraphic(10)[native] nvarchar(10) varchar(10) nvarchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) nvarchar(10) with null 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) with null
xml   longtext charset utf8mb4 text string string nvarchar(max) xml[native] dbclob(1073741823) dbclob(1073741823) CCSID 13488 text nclob string string string string string long nvarchar with null longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) xml[native] varchar(16777216) clob(1048544000) char set unicode nvarchar(16000) with null