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) |