Data Type Mapping

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:

  1. 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. 
  2. 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:

GroupTableAction
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.

GroupTableAction
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) anColumnProperties /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.

  1. Select the required source DBMS in Source Location Class; displays the mapping of source DBMS data type to HVR catalog data type.
  2. 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:

  1. 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).
  2. 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.


Source Location Class

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.

Target Location Class
  • 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.
  • 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.
Data Type HVR Capture Support HVR Catalog Data Type
bigintNativebigint
decfloatNativedecfloat
decimalNativedecimal
doubleNativedouble
integerNativeinteger
numericNativenumeric (db2i)
realNativereal
smallintNativesmallint
dateNativeansidate
timeNativetime2
timestampNativetimestamp
charNativechar
clobNativeclob
varcharNativevarchar
binaryNativebinary
blobNativeblob
varbinaryNativevarbinary
datalinkExtended<<datalink>>
xmlExtended<<xml>>
rowidExtended<<rowid>>
dbclobNativeclob
graphicNativenchar
vargraphicNativenvarchar
user definedExtended<<user defined>>
Data Type HVR Capture Support HVR Catalog Data Type
bigintNativebigint
decfloatNativedecfloat
decimalNativedecimal
doubleNativedouble
floatNativedouble
integerNativeinteger
numericNativedecimal
realNativereal
smallintNativesmallint
dateNativeansidate
timeNativetime
timestampNativetimestamp
charNativechar
char for bit dataNativebinary
clobNativeclob
long varcharNativelong varchar (db2)
long varchar for bit dataNativelong varbinary
varcharNativevarchar
varchar for bit dataNativevarbinary
binaryNativebinary
blobNativeblob
varbinaryNativevarbinary
dbclobNativedbclob
graphicNativegraphic
long vargraphicNativelong nvarchar (db2)
nclobNativedbclob
vargraphicNativevargraphic
xmlNot supported
rowidNot supported
user definedNot supported
Data Type HVR Capture Support HVR Catalog Data Type
smallintNativesmallint
integerNativeinteger
bigintNativebigint
decimalNativedecimal
decfloatNativedecfloat
realNativereal
doubleNativedouble
dateNativeansidate
timeNativetime2
timstamp without time zoneNativetimestamp
timestamp with time zoneNativedb2 timestamp with time zone
charNativechar
varcharNativevarchar
clobNativeclob
binaryNativebinary
blobNativeblob
varbinaryNativevarbinary
dbclobNativenclob
graphicNativenchar
vargraphicNativenvarchar
xmlNativeclob
rowidNot Supported
Data Type HVR Capture Support HVR Catalog Data Type
bigintNativebigint
decfloatExtended<<decfloat>>
decimalNativedecimal
doubleNativedouble
integerNativeinteger
numericNativenumeric (db2i)
realNativereal
smallintNativesmallint
dateNativeansidate
timeNativetime2
timestampNativetimestamp
charNativechar
clobNativeclob
varcharNativevarchar
binaryNativebinary
blobNativeblob
varbinaryNativevarbinary
datalinkExtended<<datalink>>
xmlExtended<<xml>>
rowidExtended<<rowid>>
dbclobNativeclob
graphicNativenchar
vargraphicNativenvarchar
user definedExtended<<user defined>>
Data Type HVR Capture Support HVR Catalog Data Type
bigintNativeinteger8
decimalNativedecimal
floatNativefloat8
float4Nativefloat4
float8Nativefloat8
integerNativeinteger4
integer1Nativeinteger1
integer2Nativeinteger2
integer4Nativeinteger4
integer8Nativeinteger8
realNativefloat4
smallintNativeinteger2
tinyintNativeinteger1
ansidateNativeansidate
ingresdateNativeingresdate
interval day to secondNativeinterval day to second (ingres)
interval year to monthNativeinterval year to month (ingres)
time with local time zoneNativetime with local time zone
time with time zoneNativetime with time zone
time without time zoneNativetime
timestamp with local timezoneNativetimestamp with local timezone
timestamp with time zoneNativetimestamp with time zone
timestamp without time zoneNativetimestamp (ingres)
cNativec
charNativechar
clobNativelong varchar
long nvarcharNativelong nvarchar
long varcharNativelong varchar
ncharNativenchar
nclobNativelong nvarchar
nvarcharNativenvarchar
textNativetext (ingres)
varcharNativevarchar
ipv4Extended<<ipv4>>
ipv6Extended<<ipv6>>
logical_keyExtended<<logical_key>>
moneyNativemoney (ingres)
uuidExtended<<uuid>>
byteNativebyte
byte varying / varbyteNativebyte varying
long byteNativelong byte
booleanNativeboolean
circularstringExtended<<circularstring>>
compoundcurveExtended<<compoundcurve>>
curvepolygonExtended<<curvepolygon>>
geometryExtended<<geometry>>
geometrycollectionExtended<<geometrycollection>>
linestringExtended<<linestring>>
multicurveExtended<<multicurve>>
multilinestringExtended<<multilinestring>>
multipointExtended<<multipoint>>
multipolygonExtended<<multipolygon>>
multisurfaceExtended<<multisurface>>
pointExtended<<point>>
polygonExtended<<polygon>>
polyhedralsurfaceExtended<<polyhedralsurface>>
tinExtended<<tin>>
triangleExtended<<triangle>>
Data Type HVR Capture Support HVR Catalog Data Type
bigintNativebigint
bigint unsignedNativebigint unsigned
bitNativebit (mysql)
boolNativetinyint signed
booleanNativetinyint signed
decNativedecimal
decimalNativedecimal
decimal unsignedNativedecimal
doubleNativedouble
double precisionNativedouble
double unsignedNativedouble
fixedNativedecimal
floatNativereal
float unsignedNativereal
intNativeint
int unsignedNativeint unsigned
integerNativeint
mediumintNativemediumint
mediumint unsignedNativemediumint unsigned
numericNativedecimal
realNativedouble
smallintNativesmallint
smallint unsignedNativesmallint unsigned
tinyintNativetinyint signed
dateNativeansidate
datetimeNativedatetime (mysql)
timeNativetime (mysql)
timestampNativetimestamp (mysql)
yearNativesmallint
binaryNativebinary
blobNativevarbinary(max)
charNativechar
char byteNativebinary
jsonNativevarchar(max)
longblobNativevarbinary(max)
longtextNativevarchar(max)
mediumblobNativevarbinary(max)
mediumtextNativevarchar(max)
textNativevarchar(max)
tinyblobNativevarbinary(max)
tinytextNativevarchar(max)
varbinaryNativevarbinary
varcharNativevarchar
geometryExtended<<geometry>>
geometrycollectionExtended<<geometrycollection>>
linestringExtended<<linestring>>
multilinestringExtended<<multilinestring>>
multipointExtended<<multipoint>>
multipolygonExtended<<multipolygon>>
pointExtended<<point>>
polygonExtended<<polygon>>
Data Type HVR Capture Support HVR Catalog Data Type
bigintNativebigint
bigint unsignedNativebigint unsigned
bitNativebit (mysql)
boolNativetinyint signed
booleanNativetinyint signed
decNativedecimal
dec unsignedNativedecimal
decimalNativedecimal
decimal unsignedNativedecimal
doubleNativedouble
double precisionNativedouble
double precision unsignedNativedouble
double unsignedNativedouble
fixedNativedecimal
fixed unsignedNativedecimal
floatNativereal
float unsignedNativereal
intNativeint
int unsignedNativeint unsigned
integerNativeint
integer unsignedNativeint unsigned
mediumintNativemediumint
mediumint unsignedNativemediumint unsigned
numericNativedecimal
numeric unsignedNativedecimal
realNativedouble
real unsignedNativedouble
smallintNativesmallint
smallint unsignedNativesmallint unsigned
tinyintNativetinyint signed
tinyint unsignedNativetinyint unsigned
dateNativeansidate
datetimeNativedatetime (mysql)
timeNativetime (mysql)
timestampNativetimestamp (mysql)
yearNativesmallint
binaryNativebinary
blobNativevarbinary(max)
charNativechar
long varcharNativevarchar(max)
longblobNativevarbinary(max)
longtextNativevarchar(max)
mediumblobNativevarbinary(max)
mediumtextNativevarchar(max)
longNativevarchar(max)
textNativevarchar(max)
tinyblobNativevarbinary(max)
tinytextNativevarchar(max)
varbinaryNativevarbinary
varcharNativevarchar
enumExtended<<enum>>
setExtended<<set>>
geometryExtended<<geometry>>
geometrycollectionExtended<<geometrycollection>>
linestringExtended<<linestring>>
multilinestringExtended<<multilinestring>>
multipointExtended<<multipoint>>
multipolygonExtended<<multipolygon>>
pointExtended<<point>>
polygonExtended<<polygon>>
jsonExtended<<json>>
Data Type HVR Capture Support HVR Catalog Data Type
binary_doubleNativebinary_double
binary_floatNativebinary_float
floatNativenumber
longNativelong
numberNativenumber
dateNativedate
interval day to secondNativeinterval day to second
interval year to monthNativeinterval year to month
timestampNativetimestamp (oracle)
timestamp with local time zoneNativetimestamp with local tz (oracle)
timestamp with time zoneNativetimestamp with tz (oracle)
charNativechar (oracle)
ncharNativenchar (oracle)
nvarchar2Nativenvarchar2
varcharNativevarchar2
varchar2Nativevarchar2
long rawNativelong raw
rawNativeraw
bfileNativebfile
blobNativeblob
clobNativeclob
nclobNativenclob
rowidNativerowid
urowidNativeurowid
extended data typesExtended<<data type>>
refExtended<<data type>>
varraysExtended<<data type>>
nested tablesExtended<<data type>>
anytypeExtended<<data type>>
anydataExtended<<data type>>
anydatasetExtended<<data type>>
uriExtended<<data type>>
xmltypeExtended<<xmltype>>
sdo_geometryExtended<<data type>>
sdo_georasterExtended<<data type>>
sdo_topo_geometryExtended<<data type>>
mediaExtended<<data type>>
Data Type HVR Capture Support HVR Catalog Data Type
smallintNativesmallint
integerNativeinteger
intNativeinteger
bigintNativebigint
int2Nativesmallint
int4Nativeinteger
int8Nativebigint
decimalNativenumber
numericNativenumber
double precisionNativefloat
realNativereal
smallserialNativesmallint
serial2Nativesmallint
serialNativeinteger
bigserialNativebigint
serial8Nativebigint
timeNativetime
time with time zoneNativetime with time zone
timestampNativepostgres timestamp
timestamp with time zoneNativepostgres timestamp with time zone
dateNativepostgres date
intervalExtended<<interval>>
char / characterNativechar
varcharNativevarchar or clob (if char length is large)
textNativeclob
byteaNativeblob
jsonNativejson
jsonbNativejsonb
booleanNativeboolean
moneyExtended<<money>>
pointExtended<<point>>
lineExtended<<line>>
lsegExtended<<_lseg>>
boxExtended<<_box>>
pathExtended<<path>>
polygonExtended<<polygon>>
circleExtended<<circle>>
cidrExtended<<cidr>>
inetExtended<<inet>>
macaddrExtended<<macaddr>>
macaddr8Extended<<macaddr8>>
bitExtended<<bit>>
bit varying / varbitExtended<<varbit>>
tsvectorExtended<<tsvector>>
tsqueryExtended<<tsquery>>
uuidExtended<<uuid>>
xmlExtended<<xml>>
int4rangeExtended<<int4range>>
int8rangeExtended<<int8range>>
numrangeExtended<<numrange>>
tsrangeExtended<<tsrange>>
tstzrangeExtended<<tstzrange>>
daterangeExtended<<daterange>>
oidExtended<<oid>>
pg_lsnExtended<<pg_lsn
domainExtended<<domain>>
user definedExtended<<user defined>>
Data Type HVR Capture Support HVR Catalog Data Type
intNativeint
bigintNativebigint
smallintNativesmallint
tinyintNativetinyint
numericNativenumeric
decimalNativenumeric
bitNativebit
moneyNativemoney
smallmoneyNativesmallmoney
floatNativefloat
realNativereal
dateNativeansidate
datetimeNativedatetime
datetime2Nativedatetime(2)
datetimeoffsetNativedatetimeoffset
smalldatetimeNativesmalldatetime
timeNativetime
charNativechar
varcharNativevarchar
textNativetext (sqlserver)
ncharNativenchar
nvarcharNativenvarchar
ntextNativentext
binaryNativebinary
varbinaryNativevarbinary
imageNativeimage
uniqueidentifierNativeuniqueidentifier
xmlNativexml
cursorExtended<<cursor>>
hierarchyidExtended<<hierarchyid>>
rowversionExtended<<rowversion>>
sql_variantExtended<<sql_variant>>
spatial geometry typesExtended<<geometry>>
spatial geography typesExtended<<geography>>
tableExtended<<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 with null date date date date date date date date date date date ansidate with null
ansidate date date bigint date date date date date date date date date date date date date ansidate with null date date date date date date date date date date date ansidate with null
bfile longblob bytea blob blob varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte with null longblob longblob bfile bfile bfile blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000) with null
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) with null bigint unsigned bigint unsigned 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 bigint bigint bigint bigint 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
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) 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
binary_double bytelen=8 double float float float float float double 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
binary_float bytelen=4 float real real real real real real real real real real float float float float float float4 with null float float binary_float binary_float binary_float real real real real float float float4 with null
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) with null 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) with null
bit tinyint boolean boolean boolean bit bit smallint smallint smallint boolean boolean boolean boolean boolean boolean boolean boolean with null tinyint tinyint number(1) number(1) number(1) boolean boolean boolean bit boolean byteint boolean with null
blob longblob bytea blob blob varbinary(max) varbinary(max) blob(2147483647) 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
boolean tinyint boolean boolean boolean bit bit smallint smallint smallint boolean boolean boolean boolean boolean boolean boolean boolean with null tinyint tinyint number(1) number(1) number(1) boolean boolean boolean bit boolean byteint boolean with null
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) with null 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 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) 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
byteint bytelen=1 tinyint smallint smallint smallint smallint 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
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 with null 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
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) with null 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) with null
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) with null 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) with null
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) with null 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
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) with null 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) with null
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) with null 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) with null
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) with null 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) with null
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) with null 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) with null
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) with null 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) with null
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) with null 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) with null
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 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
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 with null datetime(0) datetime(0) date date date timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with null
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 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
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 with null datetime(3) datetime(3) timestamp(6) timestamp(6) timestamp(6) timestamp-millis timestamp(3) timestamp datetime timestamp_ntz(3) timestamp(3) ansidate with null
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 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
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 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) timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone with null
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 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) timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone with null
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 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
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) with null 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) with null
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) with null 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) with null
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) 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
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) 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
double bytelen=8 double float float float float float double 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
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 with null 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 with null
float bytelen=8 double float float float float float double 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
float4 bytelen=4 float real real real real real real real real real real float float float float float float4 with null float float binary_float binary_float binary_float real real real real float float float4 with null
float8 bytelen=8 double float float float float float double 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) nchar(10) graphic(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 blob blob varbinary(max) varbinary(max) blob(2147483647) 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(0) timestamp timestamp timestamp timestamp timestamp timestamp ingresdate with null 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 bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint with null int unsigned int unsigned number(10) number(10) number(10) bigint bigint bigint bigint number(38) bigint bigint with null
int bytelen=4 int integer integer integer int int integer 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
integer bytelen=4 int integer integer integer int int integer 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
integer1 bytelen=1 tinyint smallint smallint smallint smallint 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 smallint smallint smallint 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 integer integer int int integer 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 bigint bigint bigint 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) 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) with null 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
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) with null 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) with null
interval month to second datetime(6) timestamp(6) varchar(100) interval month to second datetime2(7) datetime2(7) timestamp(12) timestamp timestamp(12) 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 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) 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 with null 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
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 with null 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
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 with null longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text json varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
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 with null longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text jsonb varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
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 with null 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 text text varchar(max) varchar(max) clob(2147483647) clob(2147483647) clob(2147483647) char clob string string string string string long varchar with null longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text char varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
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 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 text text nvarchar(max) nvarchar(max) dbclob(1073741823) dbclob(1073741823) CCSID 13488 dbclob(1073741823) 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 raw longblob bytea blob blob varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte with null longblob longblob long raw long raw long raw blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000) with null
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 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 text text varchar(max) varchar(max) long varchar 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 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 text text varchar(max) varchar(max) clob(2147483647) 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 text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000) with null
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 with null longtext charset utf8mb4 longtext charset utf8mb4 long 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 integer integer integer int int integer integer integer integer integer int int int int int integer with null mediumint unsigned mediumint unsigned number(8) number(8) number(8) integer integer integer int number(38) integer integer with null
mediumint bytelen=3 mediumint integer integer integer int int integer integer integer integer integer int int int int int integer with null mediumint mediumint 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) decimal(14,2) money with null 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
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 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 number(19,4) decimal(19,4) money with null
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) 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
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) 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
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 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
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 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 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) with null 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) with null
number prec=10scale=-127 double float float float float float double double double float double double double double double double float with null double double float(10) float(10) float(10) float float float float float float float with null
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) 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) number(10,3) decimal(10,3) with null
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) with null decimal(26) decimal(26) number(26) number(26) number(26) decimal(26) numeric(26) decimal(26) numeric(26) number(26) number(26) decimal(26) with null
number prec=6 int numeric(6) integer integer int int integer integer integer decimal(6) decimal(6) int int int int int integer with null int int number(6) number(6) number(6) integer numeric(6) integer int number(6) number(6) integer with null
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) 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) decimal(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) number(6) decimal(6) decimal(6) with null
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) 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 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) with null decimal(26) decimal(26) number(26) number(26) number(26) decimal(26) numeric(26) decimal(26) numeric(26) number(26) decimal(26) decimal(26) with null
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) 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
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) 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
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 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
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) 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
postgres date date date bigint date date date date date date date date date date date date date ansidate with null date date date date date date date date date date date ansidate with null
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 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) timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone with null
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 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
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) with null varbinary(10) varbinary(10) raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10) binary(10) varbyte(10) varchar(10) with null
real bytelen=4 float real real real real real real real real real real float float float float float float4 with null float float binary_float binary_float binary_float real real real real 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) char(18) with null 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) with null
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) 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 smalldatetime timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp ingresdate with null datetime(0) datetime(0) date date date timestamp-millis timestamp(0) timestamp smalldatetime timestamp_ntz(0) timestamp(0) ansidate with null
smallint unsigned bytelen=2 smallint unsigned integer integer integer int int integer integer integer integer integer int int int int int integer with null smallint unsigned smallint unsigned number(5) number(5) number(5) integer integer integer int number(38) integer integer with null
smallint bytelen=2 smallint smallint smallint smallint smallint 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
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) 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 number(10,4) decimal(10,4) decimal(10,4) with null
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) with null 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
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 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) 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 with null 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 with null
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 with null 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
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 with null 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 with null
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 with null 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 with null
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 with null 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 with null
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 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) timestamp timestamp(0) 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(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 (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 with null 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 with null
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 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 (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) 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
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 with null 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 with null
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 with null 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 with null
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 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) timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone with null
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 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) 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) timestamp timestamp(0) 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
tinyint signed bytelen=1 tinyint smallint smallint smallint smallint 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 smallint smallint smallint tinyint tinyint smallint smallint smallint smallint tinyint smallint smallint smallint smallint smallint smallint with null tinyint unsigned tinyint unsigned number(3) number(3) number(3) smallint smallint smallint tinyint number(38) smallint smallint with null
tinyint bytelen=1 tinyint unsigned smallint smallint smallint tinyint tinyint smallint smallint smallint smallint tinyint smallint smallint smallint smallint smallint smallint with null tinyint unsigned tinyint unsigned number(3) number(3) number(3) smallint smallint smallint tinyint number(38) smallint smallint with null
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) with null binary(16) binary(16) raw(16) raw(16) raw(16) char(36) char(36) char(36) uniqueidentifier 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) varchar(100) with null 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) with null
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) with null varbinary(10) varbinary(10) raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10) binary(10) varbyte(10) varchar(10) with null
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 with null longblob longblob blob blob blob blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000) with null
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) with null varbinary(10) varbinary(10) raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10) binary(10) varbyte(10) varchar(10) with null
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) with null 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) with null
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) with null 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) with null
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) with null 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) with null
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) with null 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) with null
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 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
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) with null 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) with null
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) with null 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) with null
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) with null 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) with null
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) 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 text text nvarchar(max) xml dbclob(1073741823) dbclob(1073741823) CCSID 13488 dbclob(1073741823) 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 varchar(16777216) clob(1048544000) char set unicode nvarchar(16000) with null