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
xmlNative1db2 xml1
rowidNot supported
user definedNot supported
1 - Since HVR 5.6.5/2, the 'xml' data type is supported as 'Native' and is mapped to the HVR Catalog Type 'db2 xml'. Action Capture /AugmentIncomplete=LOB is required to capture xml type from DB2 for Linux, UNIX and Windows.
Data Type HVR Capture Support HVR Catalog Data Type
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
xmlNativedb2 xml1
rowidNot Supported
1 - Since HVR 5.6.5/2, the 'xml' data type is mapped to the HVR Catalog Type 'db2 xml'.
Data Type HVR Capture Support HVR Catalog Data Type
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 date date date date date date date date date date date ansidate
ansidate date date bigint date date date date date date date date date date date date date ansidate date date date date date date date date date date date ansidate
bfile longblob bytea blob blob varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte longblob longblob bfile bfile bfile blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000)
bigint unsigned bytelen=8 bigint unsigned numeric(20) float decimal(20) numeric(20) numeric(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) bigint unsigned bigint unsigned number(20) number(20) number(20) decimal(20) numeric(20) decimal(20) numeric(20) number(38) decimal(20) decimal(20)
bigint bytelen=8 bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint number(19) number(19) number(19) bigint bigint bigint bigint number(38) bigint bigint
binary bytelen=10 binary(10) bytea blob blob binary(10) binary(10) char(10) for bit data binary(10) binary(10) bytea binary(10) binary binary binary char(2) binary byte(10) binary(10) binary(10) raw(10) raw(10) raw(10) blob bytea char(10) binary(10) binary(10) byte(10) char(10)
binary_double bytelen=8 double float float float float float double double double float double double double double double double float double double binary_double binary_double binary_double float float float float float float float
binary_float bytelen=4 float real real real real real real real real real real float float float float float float4 float float binary_float binary_float binary_float real real real real float float float4
bit (mysql) bitlen=32 bit(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) bit(32) bit(32) varchar2(32 byte) varchar2(32 byte) varchar2(32 byte) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) char set latin casespecific varchar(32)
bit tinyint boolean boolean boolean bit bit smallint smallint smallint boolean boolean boolean boolean boolean boolean boolean boolean tinyint tinyint number(1) number(1) number(1) boolean boolean boolean bit boolean byteint boolean
blob longblob bytea blob blob varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte longblob longblob blob blob blob blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000)
boolean tinyint boolean boolean boolean bit bit smallint smallint smallint boolean boolean boolean boolean boolean boolean boolean boolean tinyint tinyint number(1) number(1) number(1) boolean boolean boolean bit boolean byteint boolean
byte varying bytelen=10 varbinary(10) bytea blob blob varbinary(10) varbinary(10) varchar(10) for bit data varbinary(10) varbinary(10) bytea varbinary(10) binary binary binary string binary byte varying(10) varbinary(10) varbinary(10) raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10) binary(10) varbyte(10) varchar(10)
byte bytelen=10 binary(10) bytea blob blob binary(10) binary(10) char(10) for bit data binary(10) binary(10) bytea binary(10) binary binary binary char(2) binary byte(10) binary(10) binary(10) raw(10) raw(10) raw(10) blob bytea char(10) binary(10) binary(10) byte(10) char(10)
byteint bytelen=1 tinyint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint i1 tinyint tinyint number(3) number(3) number(3) smallint smallint smallint smallint number(38) byteint i1
c bytelen=10encoding=UTF-8 char(10) charset utf8mb4 char(10) char(10) char(10) char(10) char(10) char(10) char(10) char(10) char(10) char(60) char(10) char(10) char(10) char(10) char(10) c10 char(10) charset utf8mb4 char(10) charset utf8mb4 char(10 byte) char(20 char) char(10 byte) char(10) char(10) char(10) char(10) varchar(10) char(10) char set latin casespecific c10
char bytelen=10encoding=UTF-8 char(10) charset utf8mb4 char(10) char(10) char(10) char(10) char(10) char(10) char(10) char(10) char(10) char(60) char(10) char(10) char(10) char(10) char(10) char(10) char(10) charset utf8mb4 char(10) charset utf8mb4 char(10 byte) char(20 char) char(10 byte) char(10) char(10) char(10) char(10) varchar(10) char(10) char set latin casespecific char(10)
char bytelen=4000encoding=UTF-8 varchar(4000) charset utf8mb4 char(4000) char(4000) char(4000) char(4000) char(4000) varchar(4000) char(4000) varchar(4000) char(4000) clob varchar(4000) varchar(4000) varchar(4000) varchar(4000) varchar(4000) char(4000) varchar(4000) charset utf8mb4 varchar(4000) charset utf8mb4 varchar2(4000 byte) clob varchar2(4000 byte) char(4000) char(4000) char(4000) char(4000) varchar(4000) char(4000) char set latin casespecific char(4000)
char bytelen=8000encoding=UTF-8 varchar(8000) charset utf8mb4 char(8000) char(8000) char(8000) char(8000) char(8000) varchar(8000) char(8000) varchar(8000) char(8000) clob varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) char(8000) varchar(8000) charset utf8mb4 varchar(8000) charset utf8mb4 clob clob clob char(8000) char(8000) varchar(8000) char(8000) varchar(8000) char(8000) char set latin casespecific char(8000)
char bytelen=40charlen=10encoding=UTF-8 char(10) charset utf8mb4 char(10) char(10) char(10) char(10) char(10) char(40) char(10) char(10) char(10) char(60) char(10) char(10) char(10) char(10) char(10) char(40) char(10) charset utf8mb4 char(10) charset utf8mb4 char(10 char) char(20 char) char(10 byte) char(10) char(10) char(40) char(10) varchar(10) char(10) char set latin casespecific char(40)
char bytelen=10encoding=WINDOWS-1252 char(10) charset latin1 char(10) char(10) char(10) char(10) char(10) char(20) char(10) char(10) char(10) char(20) char(10) char(10) char(10) char(10) char(10) char(20) char(10) charset latin1 char(10) charset latin1 char(10 char) char(10 char) char(10 byte) char(10) char(10) char(20) char(10) varchar(10) char(10) char set latin casespecific char(20)
char (oracle) bytelen=10encoding=UTF-8 char(10) charset utf8mb4 char(10) char(10) char(10) char(10) char(10) char(10) char(10) char(10) char(10) char(60) char(10) char(10) char(10) char(10) char(10) char(10) char(10) charset utf8mb4 char(10) charset utf8mb4 char(10 byte) char(20 char) char(10 byte) char(10) char(10) char(10) char(10) varchar(10) char(10) char set latin casespecific char(10)
char (oracle) bytelen=2000encoding=UTF-8 varchar(2000) charset utf8mb4 char(2000) char(2000) char(2000) char(2000) char(2000) varchar(2000) char(2000) varchar(2000) char(2000) clob varchar(2000) varchar(2000) varchar(2000) varchar(2000) varchar(2000) char(2000) varchar(2000) charset utf8mb4 varchar(2000) charset utf8mb4 char(2000 byte) clob char(2000 byte) char(2000) char(2000) char(2000) char(2000) varchar(2000) char(2000) char set latin casespecific char(2000)
char (oracle) bytelen=40charlen=10encoding=UTF-8 char(10) charset utf8mb4 char(10) char(10) char(10) char(10) char(10) char(40) char(10) char(10) char(10) char(60) char(10) char(10) char(10) char(10) char(10) char(40) char(10) charset utf8mb4 char(10) charset utf8mb4 char(10 char) char(20 char) char(10 byte) char(10) char(10) char(40) char(10) varchar(10) char(10) char set latin casespecific char(40)
char (oracle) bytelen=10encoding=WINDOWS-1252 char(10) charset latin1 char(10) char(10) char(10) char(10) char(10) char(20) char(10) char(10) char(10) char(20) char(10) char(10) char(10) char(10) char(10) char(20) char(10) charset latin1 char(10) charset latin1 char(10 char) char(10 char) char(10 byte) char(10) char(10) char(20) char(10) varchar(10) char(10) char set latin casespecific char(20)
clob encoding=UTF-8 longtext charset utf8mb4 text text text varchar(max) varchar(max) clob(2147483647) clob(2147483647) clob(2147483647) text clob string string string string string long varchar longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000)
date datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp ingresdate datetime(0) datetime(0) date date date timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0)
date (sybase) date date bigint date date date date date date date date date date date date date ansidate date date date date date date date date date date date ansidate
datetime (mysql) prec_sec=0 datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone datetime(0) datetime(0) timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0)
datetime (sybase) datetime(3) timestamp(3) varchar(100) timestamp-millis datetime2(3) datetime2(3) timestamp(3) timestamp timestamp(3) timestamp(3) timestamp timestamp timestamp timestamp timestamp timestamp ingresdate datetime(3) datetime(3) timestamp(6) timestamp(6) timestamp(6) timestamp-millis timestamp(3) timestamp datetime2(3) timestamp_ntz(3) timestamp(3) ansidate
datetime datetime(3) timestamp(3) varchar(100) timestamp-millis datetime datetime timestamp(3) timestamp timestamp(3) timestamp(3) timestamp timestamp timestamp timestamp timestamp timestamp ingresdate datetime(3) datetime(3) timestamp(6) timestamp(6) timestamp(6) timestamp-millis timestamp(3) timestamp datetime timestamp_ntz(3) timestamp(3) ansidate
datetime2 prec_sec=0 datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone datetime(0) datetime(0) timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0)
datetimeoffset datetime(0) timestamp(0) with time zone varchar(100) timestamp-millis datetimeoffset(0) datetimeoffset(0) timestamp(0) timestamp timestamp(0) with time zone timestamp(0) with time zone timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with time zone datetime(0) datetime(0) timestamp(0) with time zone timestamp(0) with time zone timestamp(0) with time zone timestamp-millis timestamp(0) with time zone timestamp datetimeoffset(0) timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone
db2 timestamp with time zone prec_sec=0 datetime(0) timestamp(0) with time zone varchar(100) timestamp-millis datetimeoffset(0) datetimeoffset(0) timestamp(0) timestamp timestamp(0) with time zone timestamp(0) with time zone timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with time zone datetime(0) datetime(0) timestamp(0) with time zone timestamp(0) with time zone timestamp(0) with time zone timestamp-millis timestamp(0) with time zone timestamp datetimeoffset(0) timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone
db2 xml encoding=UTF-8 longtext charset utf8mb4 text text text varchar(max) xml xml clob(2147483647) xml text clob string string string string string long varchar longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text text varchar(65535) xml varchar(16777216) clob(2097088000) char set latin varchar(32000)
dbclob longtext charset utf8mb4 text text text nvarchar(max) nvarchar(max) dbclob(1073741823) dbclob(1073741823) CCSID 13488 dbclob(1073741823) text nclob string string string string string long nvarchar longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode nvarchar(16000)
decfloat prec=16 varchar(42) charset utf8mb4 varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) decfloat(16) decfloat(16) decfloat(16) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) charset utf8mb4 varchar(42) charset utf8mb4 varchar2(42 byte) varchar2(42 byte) varchar2(42 byte) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) char set latin casespecific varchar(42)
decfloat prec=34 varchar(42) charset utf8mb4 varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) decfloat(34) decfloat(34) decfloat(34) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) charset utf8mb4 varchar(42) charset utf8mb4 varchar2(42 byte) varchar2(42 byte) varchar2(42 byte) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) varchar(42) char set latin casespecific varchar(42)
decimal prec=10scale=3 decimal(10,3) numeric(10,3) varchar(12) decimal(10,3) numeric(10,3) numeric(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) number(10,3) number(10,3) number(10,3) decimal(10,3) numeric(10,3) decimal(10,3) numeric(10,3) number(10,3) decimal(10,3) decimal(10,3)
decimal prec=6 decimal(6) numeric(6) varchar(8) decimal(6) numeric(6) numeric(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) number(6) number(6) number(6) decimal(6) numeric(6) decimal(6) numeric(6) number(6) decimal(6) decimal(6)
double bytelen=8 double float float float float float double double double float double double double double double double float double double binary_double binary_double binary_double float float float float float float float
epoch timestamp(0)null timestamp(0) bigint timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) with local time zone timestamp(0)null timestamp(0)null timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with local time zone
float bytelen=8 double float float float float float double double double float double double double double double double float double double binary_double binary_double binary_double float float float float float float float
float4 bytelen=4 float real real real real real real real real real real float float float float float float4 float float binary_float binary_float binary_float real real real real float float float4
float8 bytelen=8 double float float float float float double double double float double double double double double double float double double binary_double binary_double binary_double float float float float float float float
graphic charlen=10 char(10) charset utf8mb4 char(10) char(10) char(10) nchar(10) nchar(10) graphic(10) nchar(10) graphic(10) char(10) nchar(10) char(10) char(10) char(10) char(10) char(10) nchar(10) char(10) charset utf8mb4 char(10) charset utf8mb4 nchar(10) nchar(10) nchar(10) char(10) char(10) varchar(40) nchar(10) varchar(10) char(10) char set unicode casespecific nchar(10)
image longblob bytea blob blob varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte longblob longblob blob blob blob blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000)
image (sybase) longblob bytea blob blob varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte longblob longblob long raw long raw long raw blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000)
ingresdate datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp ingresdate datetime(0) datetime(0) date date date timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0)
int unsigned bytelen=4 int unsigned bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint int unsigned int unsigned number(10) number(10) number(10) bigint bigint bigint bigint number(38) bigint bigint
int bytelen=4 int integer integer integer int int integer integer integer integer integer int int int int int integer int int number(10) number(10) number(10) integer integer integer int number(38) integer integer
integer bytelen=4 int integer integer integer int int integer integer integer integer integer int int int int int integer int int number(10) number(10) number(10) integer integer integer int number(38) integer integer
integer1 bytelen=1 tinyint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint i1 tinyint tinyint number(3) number(3) number(3) smallint smallint smallint smallint number(38) byteint i1
integer2 bytelen=2 smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint number(5) number(5) number(5) smallint smallint smallint smallint number(38) smallint smallint
integer4 bytelen=4 int integer integer integer int int integer integer integer integer integer int int int int int integer int int number(10) number(10) number(10) integer integer integer int number(38) integer integer
integer8 bytelen=8 bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint number(19) number(19) number(19) bigint bigint bigint bigint number(38) bigint bigint
interval day to second (ingres) datetime(0) timestamp(0) varchar(100) interval month to second datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) interval day to second(0) datetime(0) datetime(0) interval day(9) to second(0) interval day(9) to second(0) interval day(9) to second(0) interval month to second timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) interval day to second(0)
interval day to second datetime(0) timestamp(0) varchar(100) interval month to second datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) interval day to second(0) datetime(0) datetime(0) interval day(0) to second(0) interval day(0) to second(0) interval day(0) to second(0) interval month to second timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) interval day to second(0)
interval month to second datetime(0) timestamp(0) varchar(100) interval month to second datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) interval day to second(0) datetime(0) datetime(0) interval day(9) to second(0) interval day(9) to second(0) interval day(9) to second(0) interval month to second timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) interval day to second(0)
interval year to month (ingres) datetime(0) timestamp(6) varchar(100) interval month to second datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(6) timestamp varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) interval year to month datetime(0) datetime(0) interval year(0) to month interval year(0) to month interval year(0) to month interval month to second timestamp(6) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) interval year to month
interval year to month datetime(0) timestamp(6) varchar(100) interval month to second datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(6) timestamp varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) interval year to month datetime(0) datetime(0) interval year(0) to month interval year(0) to month interval year(0) to month interval month to second timestamp(6) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) interval year to month
json longtext charset utf8mb4 json text text varchar(max) varchar(max) clob(2147483647) clob(2147483647) clob(2147483647) text clob string string string string string long varchar longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text json varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000)
jsonb longtext charset utf8mb4 jsonb text text varchar(max) varchar(max) clob(2147483647) clob(2147483647) clob(2147483647) text clob string string string string string long varchar longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text jsonb varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000)
long byte longblob bytea blob blob varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte longblob longblob blob blob blob blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000)
long char encoding=UTF-8 longtext charset utf8mb4 char text text varchar(max) varchar(max) clob(2147483647) clob(2147483647) clob(2147483647) char clob string string string string string long varchar longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text char varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000)
long nvarchar (db2) longtext charset utf8mb4 text text text nvarchar(max) nvarchar(max) long vargraphic dbclob(1073741823) CCSID 13488 dbclob(1073741823) text nclob string string string string string long nvarchar longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode nvarchar(16000)
long nvarchar longtext charset utf8mb4 text text text nvarchar(max) nvarchar(max) dbclob(1073741823) dbclob(1073741823) CCSID 13488 dbclob(1073741823) text nclob string string string string string long nvarchar longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode nvarchar(16000)
long raw longblob bytea blob blob varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte longblob longblob long raw long raw long raw blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000)
long varbinary longblob bytea blob blob varbinary(max) varbinary(max) long varchar for bit data blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte longblob longblob blob blob blob blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000)
long varchar (db2) encoding=UTF-8 longtext charset utf8mb4 text text text varchar(max) varchar(max) long varchar clob(2147483647) clob(2147483647) text clob string string string string string long varchar longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000)
long varchar encoding=UTF-8 longtext charset utf8mb4 text text text varchar(max) varchar(max) clob(2147483647) clob(2147483647) clob(2147483647) text clob string string string string string long varchar longtext charset utf8mb4 longtext charset utf8mb4 clob clob clob text text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000)
long encoding=UTF-8 longtext charset utf8mb4 text text text varchar(max) varchar(max) clob(2147483647) clob(2147483647) clob(2147483647) text clob string string string string string long varchar longtext charset utf8mb4 longtext charset utf8mb4 long long long text text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000)
mediumint unsigned bytelen=3 mediumint unsigned integer integer integer int int integer integer integer integer integer int int int int int integer mediumint unsigned mediumint unsigned number(8) number(8) number(8) integer integer integer int number(38) integer integer
mediumint bytelen=3 mediumint integer integer integer int int integer integer integer integer integer int int int int int integer mediumint mediumint number number number integer integer integer int number(38) integer integer
money (ingres) decimal(14,2) numeric(14,2) varchar(16) decimal(14,2) money money decimal(14,2) decimal(14,2) decimal(14,2) decimal(14,2) decimal(14,2) decimal(14,2) decimal(14,2) decimal(14,2) decimal(14,2) decimal(14,2) money decimal(14,2) decimal(14,2) number(14,2) number(14,2) number(14,2) decimal(14,2) numeric(14,2) decimal(14,2) money number(14,2) decimal(14,2) money
money decimal(19,4) numeric(19,4) varchar(21) decimal(19,4) money money decimal(19,4) decimal(19,4) decimal(19,4) decimal(19,4) decimal(19,4) decimal(19,4) decimal(19,4) decimal(19,4) decimal(19,4) decimal(19,4) money decimal(19,4) decimal(19,4) number(19,4) number(19,4) number(19,4) decimal(19,4) numeric(19,4) decimal(19,4) money number(19,4) decimal(19,4) money
nchar charlen=10 char(10) charset utf8mb4 char(10) char(10) char(10) nchar(10) nchar(10) graphic(10) nchar(10) graphic(10) char(10) nchar(10) char(10) char(10) char(10) char(10) char(10) nchar(10) char(10) charset utf8mb4 char(10) charset utf8mb4 nchar(10) nchar(10) nchar(10) char(10) char(10) varchar(40) nchar(10) varchar(10) char(10) char set unicode casespecific nchar(10)
nchar (oracle) charlen=10 char(10) charset utf8mb4 char(10) char(10) char(10) nchar(10) nchar(10) graphic(10) nchar(10) graphic(10) char(10) nchar(10) char(10) char(10) char(10) char(10) char(10) nchar(10) char(10) charset utf8mb4 char(10) charset utf8mb4 nchar(10) nchar(10) nchar(10) char(10) char(10) varchar(40) nchar(10) varchar(10) char(10) char set unicode casespecific nchar(10)
nclob longtext charset utf8mb4 text text text nvarchar(max) nvarchar(max) dbclob(1073741823) dbclob(1073741823) CCSID 13488 dbclob(1073741823) text nclob string string string string string long nvarchar longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode nvarchar(16000)
ntext longtext charset utf8mb4 text text text nvarchar(max) nvarchar(max) dbclob(1073741823) dbclob(1073741823) CCSID 13488 dbclob(1073741823) text nclob string string string string string long nvarchar longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode nvarchar(16000)
number decimal(65,4) numeric float decimal(1000,4) numeric(38,4) numeric(38,4) decimal(31,4) decimal(63,4) decimal(31,4) numeric decimal decimal(38,4) decimal(38,4) decimal(38,4) decimal(38,4) decimal(38,4) decimal(39,4) decimal(65,4) decimal(65,4) number number number decimal(1000,4) numeric decimal(38,4) numeric(38,4) number(38,4) number decimal(38,4)
number prec=10scale=-127 double float float float float float double double double float double double double double double double float double double float(10) float(10) float(10) float float float float float float float
number prec=10scale=3 decimal(10,3) numeric(10,3) float decimal(10,3) numeric(10,3) numeric(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) number(10,3) number(10,3) number(10,3) decimal(10,3) numeric(10,3) decimal(10,3) numeric(10,3) number(10,3) number(10,3) decimal(10,3)
number prec=26 decimal(26) numeric(26) float decimal(26) numeric(26) numeric(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) number(26) number(26) number(26) decimal(26) numeric(26) decimal(26) numeric(26) number(26) number(26) decimal(26)
number prec=6 int numeric(6) integer integer int int integer integer integer decimal(6) decimal(6) int int int int int integer int int number(6) number(6) number(6) integer numeric(6) integer int number(6) number(6) integer
numeric (db2i) prec=10scale=3 decimal(10,3) numeric(10,3) varchar(12) decimal(10,3) numeric(10,3) numeric(10,3) decimal(10,3) numeric(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) number(10,3) number(10,3) number(10,3) decimal(10,3) numeric(10,3) decimal(10,3) numeric(10,3) number(10,3) decimal(10,3) decimal(10,3)
numeric (db2i) prec=6 decimal(6) numeric(6) varchar(8) decimal(6) numeric(6) numeric(6) decimal(6) numeric(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) number(6) number(6) number(6) decimal(6) numeric(6) decimal(6) numeric(6) number(6) decimal(6) decimal(6)
numeric prec=10scale=3 decimal(10,3) numeric(10,3) varchar(12) decimal(10,3) numeric(10,3) numeric(10,3) decimal(10,3) numeric(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) decimal(10,3) number(10,3) number(10,3) number(10,3) decimal(10,3) numeric(10,3) decimal(10,3) numeric(10,3) number(10,3) decimal(10,3) decimal(10,3)
numeric prec=26 decimal(26) numeric(26) varchar(28) decimal(26) numeric(26) numeric(26) decimal(26) numeric(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) decimal(26) number(26) number(26) number(26) decimal(26) numeric(26) decimal(26) numeric(26) number(26) decimal(26) decimal(26)
numeric prec=6 decimal(6) numeric(6) varchar(8) decimal(6) numeric(6) numeric(6) decimal(6) numeric(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) decimal(6) number(6) number(6) number(6) decimal(6) numeric(6) decimal(6) numeric(6) number(6) decimal(6) decimal(6)
nvarchar charlen=10 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) nvarchar(10) nvarchar(10) vargraphic(10) nvarchar(10) vargraphic(10) varchar(10) nvarchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) nvarchar(10) varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 nvarchar2(10) nvarchar2(10) nvarchar2(10) varchar(10) varchar(10) varchar(40) nvarchar(10) varchar(10) varchar(10) char set unicode casespecific nvarchar(10)
nvarchar(max) longtext charset utf8mb4 text text text nvarchar(max) nvarchar(max) dbclob(1073741823) dbclob(1073741823) CCSID 13488 dbclob(1073741823) text nclob string string string string string long nvarchar longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode nvarchar(16000)
nvarchar2 charlen=10 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) nvarchar(10) nvarchar(10) vargraphic(10) nvarchar(10) vargraphic(10) varchar(10) nvarchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) nvarchar(10) varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 nvarchar2(10) nvarchar2(10) nvarchar2(10) varchar(10) varchar(10) varchar(40) nvarchar(10) varchar(10) varchar(10) char set unicode casespecific nvarchar(10)
postgres date date date bigint date date date date date date date date date date date date date ansidate date date date date date date date date date date date ansidate
postgres timestamp with time zone datetime(0) timestamp(0) with time zone varchar(100) timestamp-millis datetimeoffset(0) datetimeoffset(0) timestamp(0) timestamp timestamp(0) with time zone timestamp(0) with time zone timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with time zone datetime(0) datetime(0) timestamp(0) with time zone timestamp(0) with time zone timestamp(0) with time zone timestamp-millis timestamp(0) with time zone timestamp datetimeoffset(0) timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone
postgres timestamp datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone datetime(0) datetime(0) timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0)
raw bytelen=10 varbinary(10) bytea blob blob varbinary(10) varbinary(10) varchar(10) for bit data varbinary(10) varbinary(10) bytea varbinary(10) binary binary binary string binary byte varying(10) varbinary(10) varbinary(10) raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10) binary(10) varbyte(10) varchar(10)
real bytelen=4 float real real real real real real real real real real float float float float float float4 float float binary_float binary_float binary_float real real real real float float float4
rowid char(18) charset ascii char(18) char(18) char(18) char(18) char(18) char(18) char(18) char(18) char(18) char(18) char(18) char(18) char(18) char(18) char(18) char(18) char(18) charset ascii char(18) charset ascii rowid rowid rowid char(18) char(18) char(18) char(18) varchar(18) char(18) char set latin casespecific char(18)
rowversion bytelen=10 binary(10) bytea blob blob binary(10) binary(10) char(10) for bit data binary(10) binary(10) bytea binary(10) binary binary binary char(2) binary byte(10) binary(10) binary(10) raw(10) raw(10) raw(10) blob bytea char(10) binary(10) binary(10) byte(10) char(10)
smalldatetime datetime(0) timestamp(0) varchar(100) timestamp-millis smalldatetime smalldatetime timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp ingresdate datetime(0) datetime(0) date date date timestamp-millis timestamp(0) timestamp smalldatetime timestamp_ntz(0) timestamp(0) ansidate
smallint unsigned bytelen=2 smallint unsigned integer integer integer int int integer integer integer integer integer int int int int int integer smallint unsigned smallint unsigned number(5) number(5) number(5) integer integer integer int number(38) integer integer
smallint bytelen=2 smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint number(5) number(5) number(5) smallint smallint smallint smallint number(38) smallint smallint
smallmoney decimal(10,4) numeric(10,4) varchar(12) decimal(10,4) smallmoney smallmoney decimal(10,4) decimal(10,4) decimal(10,4) decimal(10,4) decimal(10,4) decimal(10,4) decimal(10,4) decimal(10,4) decimal(10,4) decimal(10,4) decimal(10,4) decimal(10,4) decimal(10,4) number(10,4) number(10,4) number(10,4) decimal(10,4) numeric(10,4) decimal(10,4) smallmoney number(10,4) decimal(10,4) decimal(10,4)
text (ingres) bytelen=10encoding=UTF-8 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(60) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) text(10) varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 varchar2(10 byte) varchar2(20 char) varchar2(10 byte) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) char set latin casespecific text(10)
text (sqlserver) encoding=WINDOWS-1252 longtext charset latin1 text text text varchar(max) varchar(max) clob(2147483647) clob(2147483647) clob(2147483647) text clob string string string string string long varchar longtext charset latin1 longtext charset latin1 clob clob clob text text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000)
text(sybase) encoding=UTF-8 longtext charset utf8mb4 text text text varchar(max) varchar(max) clob(2147483647) clob(2147483647) clob(2147483647) text clob string string string string string long varchar longtext charset utf8mb4 longtext charset utf8mb4 long long long text text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000)
time (mysql) prec_sec=0 time(0) time(0) integer time(3) time(0) time(0) time time time time(0) time varchar(25) varchar(25) varchar(25) varchar(25) varchar(25) time(0) without time zone time(0) time(0) timestamp(0) timestamp(0) timestamp(0) time(3) time(0) timestamp time(0) time(0) time(0) time(0) without time zone
time (sybase) prec_sec=0 time(3) time(3) integer time(3) time(3) time(3) time time time time(3) time varchar(25) varchar(25) varchar(25) varchar(25) varchar(25) time(3) without time zone time(3) time(3) timestamp(3) timestamp(3) timestamp(3) time(3) time(3) timestamp time(3) time(3) time(3) time(3) without time zone
time with local time zone time(0) time(0) integer time(3) time(0) time(0) time time time time(0) time varchar(25) varchar(25) varchar(25) varchar(25) varchar(25) time(0) with local time zone time(0) time(0) timestamp(0) with local time zone timestamp(0) with local time zone timestamp(0) with local time zone time(3) time(0) timestamp time(0) time(0) time(0) time(0) with local time zone
time with time zone time(0) time(0) with time zone integer time(3) time(0) time(0) time time time time(0) time varchar(25) varchar(25) varchar(25) varchar(25) varchar(25) time(0) with time zone time(0) time(0) timestamp(0) with time zone timestamp(0) with time zone timestamp(0) with time zone time(3) time(0) with time zone timestamp time(0) time(0) time(0) with time zone time(0) with time zone
time prec_sec=0 time(0) time(0) integer time(3) time(0) time(0) time time time time(0) time varchar(25) varchar(25) varchar(25) varchar(25) varchar(25) time(0) without time zone time(0) time(0) timestamp(0) timestamp(0) timestamp(0) time(3) time(0) timestamp time(0) time(0) time(0) time(0) without time zone
time prec_sec=3 time(3) time(3) integer time(3) time(3) time(3) time time time time(3) time varchar(25) varchar(25) varchar(25) varchar(25) varchar(25) time(3) without time zone time(3) time(3) timestamp(3) timestamp(3) timestamp(3) time(3) time(3) timestamp time(3) time(3) time(3) time(3) without time zone
time2 time(6) time(0) integer time(3) time(0) time(0) time time time time(0) time varchar(25) varchar(25) varchar(25) varchar(25) varchar(25) time(0) without time zone time(6) time(6) timestamp(0) timestamp(0) timestamp(0) time(3) time(0) timestamp time(0) time(0) time(0) time(0) without time zone
timestamp (db2) prec_sec=0 datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone datetime(0) datetime(0) timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0)
timestamp (ingres) datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone datetime(0) datetime(0) timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0)
timestamp (mysql) timestamp(0)null timestamp(0) bigint timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) with local time zone timestamp(0)null timestamp(0)null timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0) with local time zone
timestamp (oracle) datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone datetime(0) datetime(0) timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0)
timestamp (sqlserver) bytelen=10 binary(10) bytea blob blob binary(10) binary(10) char(10) for bit data binary(10) binary(10) bytea binary(10) binary binary binary char(2) binary byte(10) binary(10) binary(10) raw(10) raw(10) raw(10) blob bytea char(10) binary(10) binary(10) byte(10) char(10)
timestamp (sybase) bytelen=10 varbinary(10) bytea blob blob varbinary(10) varbinary(10) varchar(10) for bit data varbinary(10) varbinary(10) bytea varbinary(10) binary binary binary string binary byte varying(10) varbinary(10) varbinary(10) raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10) binary(10) varbyte(10) varchar(10)
timestamp with local time zone datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with local time zone datetime(0) datetime(0) timestamp(0) with local time zone timestamp(0) with local time zone timestamp(0) with local time zone timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ltz(0) timestamp(0) timestamp(0) with local time zone
timestamp with local tz (oracle) datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with local time zone datetime(0) datetime(0) timestamp(0) with local time zone timestamp(0) with local time zone timestamp(0) with local time zone timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ltz(0) timestamp(0) timestamp(0) with local time zone
timestamp with time zone datetime(0) timestamp(0) with time zone varchar(100) timestamp-millis datetimeoffset(0) datetimeoffset(0) timestamp(0) timestamp timestamp(0) with time zone timestamp(0) with time zone timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with time zone datetime(0) datetime(0) timestamp(0) with time zone timestamp(0) with time zone timestamp(0) with time zone timestamp-millis timestamp(0) with time zone timestamp datetimeoffset(0) timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone
timestamp with tz (oracle) datetime(0) timestamp(0) with time zone varchar(100) timestamp-millis datetimeoffset(0) datetimeoffset(0) timestamp(0) timestamp timestamp(0) with time zone timestamp(0) with time zone timestamp timestamp timestamp varchar(100) timestamp timestamp timestamp(0) with time zone datetime(0) datetime(0) timestamp(0) with time zone timestamp(0) with time zone timestamp(0) with time zone timestamp-millis timestamp(0) with time zone timestamp datetimeoffset(0) timestamp_tz(0) timestamp(0) with time zone timestamp(0) with time zone
timestamp prec_sec=0 datetime(0) timestamp(0) varchar(100) timestamp-millis datetime2(0) datetime2(0) timestamp(0) timestamp timestamp(0) timestamp(0) timestamp timestamp timestamp timestamp timestamp timestamp timestamp(0) without time zone datetime(0) datetime(0) timestamp(0) timestamp(0) timestamp(0) timestamp-millis timestamp(0) timestamp datetime2(0) timestamp_ntz(0) timestamp(0) timestamp(0)
tinyint signed bytelen=1 tinyint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint i1 tinyint tinyint number(3) number(3) number(3) smallint smallint smallint smallint number(38) byteint i1
tinyint unsigned bytelen=1 tinyint unsigned smallint smallint smallint tinyint tinyint smallint smallint smallint smallint tinyint smallint smallint smallint smallint smallint smallint tinyint unsigned tinyint unsigned number(3) number(3) number(3) smallint smallint smallint tinyint number(38) smallint smallint
tinyint bytelen=1 tinyint unsigned smallint smallint smallint tinyint tinyint smallint smallint smallint smallint tinyint smallint smallint smallint smallint smallint smallint tinyint unsigned tinyint unsigned number(3) number(3) number(3) smallint smallint smallint tinyint number(38) smallint smallint
uniqueidentifier binary(16) char(36) char(36) char(36) uniqueidentifier uniqueidentifier char(16) for bit data binary(16) binary(16) char(36) binary(16) char(36) char(36) char(36) char(36) char(36) byte(16) binary(16) binary(16) raw(16) raw(16) raw(16) char(36) char(36) char(36) uniqueidentifier binary(16) byte(16) char(36)
unitext longtext charset utf8mb4 text text text nvarchar(max) nvarchar(max) dbclob(1073741823) dbclob(1073741823) CCSID 13488 dbclob(1073741823) text nclob string string string string string long nvarchar longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) nvarchar(max) varchar(16777216) clob(1048544000) char set unicode nvarchar(16000)
univarchar charlen=10 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) nvarchar(10) nvarchar(10) vargraphic(10) nvarchar(10) vargraphic(10) varchar(10) nvarchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) nvarchar(10) varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 nvarchar2(10) nvarchar2(10) nvarchar2(10) varchar(10) varchar(10) varchar(40) nvarchar(10) varchar(10) varchar(10) char set unicode casespecific nvarchar(10)
unsigned bigint bytelen=8 bigint unsigned numeric(20) float decimal(20) numeric(20) numeric(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) decimal(20) bigint unsigned bigint unsigned number(20) number(20) number(20) decimal(20) numeric(20) decimal(20) numeric(20) number(38) decimal(20) decimal(20)
unsigned int bytelen=4 int unsigned bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint bigint int unsigned int unsigned number(10) number(10) number(10) bigint bigint bigint bigint number(38) bigint bigint
unsigned smallint bytelen=2 smallint unsigned integer integer integer int int integer integer integer integer integer int int int int int integer smallint unsigned smallint unsigned number(5) number(5) number(5) integer integer integer int number(38) integer integer
urowid bytelen=100 varchar(100) charset ascii varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) charset ascii varchar(100) charset ascii urowid(75) urowid(75) urowid(75) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) char set latin casespecific varchar(100)
varbinary bytelen=10 varbinary(10) bytea blob blob varbinary(10) varbinary(10) varchar(10) for bit data varbinary(10) varbinary(10) bytea varbinary(10) binary binary binary string binary byte varying(10) varbinary(10) varbinary(10) raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10) binary(10) varbyte(10) varchar(10)
varbinary (sybase) bytelen=10 varbinary(10) bytea blob blob varbinary(10) varbinary(10) varchar(10) for bit data varbinary(10) varbinary(10) bytea varbinary(10) binary binary binary string binary byte varying(10) varbinary(10) varbinary(10) raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10) binary(10) varbyte(10) varchar(10)
varbinary(max) longblob bytea blob blob varbinary(max) varbinary(max) blob(2147483647) blob(2147483647) blob(2147483647) bytea blob binary binary binary string binary long byte longblob longblob blob blob blob blob bytea varchar(65535) varbinary(max) binary(8388608) blob(2097088000) varchar(32000)
varbyte bytelen=10 varbinary(10) bytea blob blob varbinary(10) varbinary(10) varchar(10) for bit data varbinary(10) varbinary(10) bytea varbinary(10) binary binary binary string binary byte varying(10) varbinary(10) varbinary(10) raw(10) raw(10) raw(10) blob bytea varchar(10) varbinary(10) binary(10) varbyte(10) varchar(10)
varchar bytelen=10encoding=UTF-8 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(60) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 varchar2(10 byte) varchar2(20 char) varchar2(10 byte) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(10)
varchar bytelen=8000encoding=UTF-8 varchar(8000) charset utf8mb4 varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) clob varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) charset utf8mb4 varchar(8000) charset utf8mb4 clob clob clob varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) char set latin casespecific varchar(8000)
varchar bytelen=40charlen=10encoding=UTF-8 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(40) varchar(10) varchar(10) varchar(10) varchar(60) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(40) varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 varchar2(10 char) varchar2(20 char) varchar2(10 byte) varchar(10) varchar(10) varchar(40) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(40)
varchar bytelen=10encoding=WINDOWS-1252 varchar(10) charset latin1 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(20) varchar(10) charset latin1 varchar(10) charset latin1 varchar2(10 char) varchar2(10 char) varchar2(10 byte) varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(20)
varchar (sybase) bytelen=10encoding=UTF-8 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(60) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 varchar2(10 byte) varchar2(20 char) varchar2(10 byte) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(10)
varchar (sybase) bytelen=8000encoding=UTF-8 varchar(8000) charset utf8mb4 varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) clob varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) charset utf8mb4 varchar(8000) charset utf8mb4 clob clob clob varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) varchar(8000) char set latin casespecific varchar(8000)
varchar (sybase) bytelen=40charlen=10encoding=UTF-8 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(40) varchar(10) varchar(10) varchar(10) varchar(60) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(40) varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 varchar2(10 char) varchar2(20 char) varchar2(10 byte) varchar(10) varchar(10) varchar(40) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(40)
varchar (sybase) bytelen=10encoding=WINDOWS-1252 varchar(10) charset latin1 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(20) varchar(10) charset latin1 varchar(10) charset latin1 varchar2(10 char) varchar2(10 char) varchar2(10 byte) varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(20)
varchar(max) encoding=WINDOWS-1252 longtext charset latin1 text text text varchar(max) varchar(max) clob(2147483647) clob(2147483647) clob(2147483647) text clob string string string string string long varchar longtext charset latin1 longtext charset latin1 clob clob clob text text varchar(65535) varchar(max) varchar(16777216) clob(2097088000) char set latin varchar(32000)
varchar2 bytelen=10encoding=UTF-8 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(60) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 varchar2(10 byte) varchar2(20 char) varchar2(10 byte) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(10)
varchar2 bytelen=40charlen=10encoding=UTF-8 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(40) varchar(10) varchar(10) varchar(10) varchar(60) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(40) varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 varchar2(10 char) varchar2(20 char) varchar2(10 byte) varchar(10) varchar(10) varchar(40) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(40)
varchar2 bytelen=10encoding=WINDOWS-1252 varchar(10) charset latin1 varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(20) varchar(10) charset latin1 varchar(10) charset latin1 varchar2(10 char) varchar2(10 char) varchar2(10 byte) varchar(10) varchar(10) varchar(20) varchar(10) varchar(10) varchar(10) char set latin casespecific varchar(20)
vargraphic charlen=10 varchar(10) charset utf8mb4 varchar(10) varchar(10) varchar(10) nvarchar(10) nvarchar(10) vargraphic(10) nvarchar(10) vargraphic(10) varchar(10) nvarchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) nvarchar(10) varchar(10) charset utf8mb4 varchar(10) charset utf8mb4 nvarchar2(10) nvarchar2(10) nvarchar2(10) varchar(10) varchar(10) varchar(40) nvarchar(10) varchar(10) varchar(10) char set unicode casespecific nvarchar(10)
xml longtext charset utf8mb4 text text text nvarchar(max) xml xml dbclob(1073741823) CCSID 13488 xml text nclob string string string string string long nvarchar longtext charset utf8mb4 longtext charset utf8mb4 nclob nclob nclob text text varchar(65535) xml varchar(16777216) clob(1048544000) char set unicode nvarchar(16000)