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:
- When a channel is built using Table Explore or using the command Hvradapt, the source DBMS data types mapped to HVR's own 'catalog data types'.
After the tables are added to a channel the mapping of data types in source DBMS (capture location) to HVR's catalog data types can be viewed in HVRGUI from the Table Explore window. - Then during HVR Refresh and Integrate, HVR's catalog data types are mapped to corresponding data types in the target DBMS (integrate location). This mapping happens at the moment the HVR Refresh is used to create target tables.
After performing HVR Refresh/Integrate the mapping of HVR's catalog data types to the target DBMS data types can be viewed in HVRGUI from the Table Explore window.
Customizing Data Type Mapping
If the automatic/default mapping of data type is not appropriate for a specific channel, it can be modified using action ColumnProperties /Datatype.
For example, by default HVR maps a number (without scale or precision) in Oracle to numeric(38,4) in SQL Server. By defining the following action, number (without scale or precision) in Oracle is mapped to float instead:
| Group | Table | Action |
|---|---|---|
| SRCGRP | * | ColumnProperties /DatatypeMatch="number[prec=0 && scale=0]" /Datatype="float" |
In the above example, ColumnProperties /DatatypeMatch is used for mapping all columns with number (without scale or precision) data type into float data type.
Alternatively, ColumnProperties /Name can be used for mapping the data type of a specific column (e.g. MYCOLUMN) into float data type.
| Group | Table | Action |
|---|---|---|
| SRCGRP | * | ColumnProperties /Name="MYCOLUMN" /Datatype="float" |
Extended Data Type Support
'Extended data types' are the DBMS data types (e.g. sql_variant in SQL Server or xmltype in Oracle) which are not mapped to native HVR data types. Instead, HVR's Extended Data Type Support feature should be used for such data types.
HVR uses action ColumnProperties /CaptureExpression for converting an extended data type to a supported data type during capture, compare or refresh (source) and ColumnProperties /IntegrateExpression for converting it back to extended data type during integrate, compare or refresh (target) respectively.
Data Type Mapping - Source to Target DBMS
In this section, you can find the mapping of data types in source DBMS to the corresponding data types in target DBMS or file format.
- Select the required source DBMS in Source Location Class; displays the mapping of source DBMS data type to HVR catalog data type.
- Select the required target DBMS in Target Location Class; displays the mapping of HVR catalog data type to target DBMS data type.
For example, to illustrate the data type mapping of timestamp with time zone in Oracle to the corresponding data type in Avro:
- Select Oracle in Source Location Class.
In the table displayed below Source Location Class, you can find that timestamp with time zone (in column HVR Catalog Data Type) is mapped to HVR's catalog data type timestamp with tz (oracle) (in column HVR Catalog Data Type). - Select Avro 1.6 and Avro 1.8 in Target Location Class.
In the table displayed below Target Location Class, you can find that timestamp with tz (oracle) (in column HVR Catalog Data Type) is mapped to varchar(100) in Avro 1.6 and timestamp-millis in Avro 1.8.
| 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 |
|---|---|---|
| bigint | Native | bigint |
| decfloat | Native | decfloat |
| decimal | Native | decimal |
| double | Native | double |
| integer | Native | integer |
| numeric | Native | numeric (db2i) |
| real | Native | real |
| smallint | Native | smallint |
| date | Native | ansidate |
| time | Native | time2 |
| timestamp | Native | timestamp |
| char | Native | char |
| clob | Native | clob |
| varchar | Native | varchar |
| binary | Native | binary |
| blob | Native | blob |
| varbinary | Native | varbinary |
| datalink | Extended | <<datalink>> |
| xml | Extended | <<xml>> |
| rowid | Extended | <<rowid>> |
| dbclob | Native | clob |
| graphic | Native | nchar |
| vargraphic | Native | nvarchar |
| user defined | Extended | <<user defined>> |
| Data Type | HVR Capture Support | HVR Catalog Data Type |
|---|---|---|
| bigint | Native | bigint |
| decfloat | Native | decfloat |
| decimal | Native | decimal |
| double | Native | double |
| float | Native | double |
| integer | Native | integer |
| numeric | Native | decimal |
| real | Native | real |
| smallint | Native | smallint |
| date | Native | ansidate |
| time | Native | time |
| timestamp | Native | timestamp |
| char | Native | char |
| char for bit data | Native | binary |
| clob | Native | clob |
| long varchar | Native | long varchar (db2) |
| long varchar for bit data | Native | long varbinary |
| varchar | Native | varchar |
| varchar for bit data | Native | varbinary |
| binary | Native | binary |
| blob | Native | blob |
| varbinary | Native | varbinary |
| dbclob | Native | dbclob |
| graphic | Native | graphic |
| long vargraphic | Native | long nvarchar (db2) |
| nclob | Native | dbclob |
| vargraphic | Native | vargraphic |
| xml | Native1 | db2 xml1 |
| rowid | Not supported | |
| user defined | Not 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 |
|---|---|---|
| smallint | Native | smallint |
| integer | Native | integer |
| bigint | Native | bigint |
| decimal | Native | decimal |
| decfloat | Native | decfloat |
| real | Native | real |
| double | Native | double |
| date | Native | ansidate |
| time | Native | time2 |
| timstamp without time zone | Native | timestamp |
| timestamp with time zone | Native | db2 timestamp with time zone |
| char | Native | char |
| varchar | Native | varchar |
| clob | Native | clob |
| binary | Native | binary |
| blob | Native | blob |
| varbinary | Native | varbinary |
| dbclob | Native | nclob |
| graphic | Native | nchar |
| vargraphic | Native | nvarchar |
| xml | Native | db2 xml1 |
| rowid | Not 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 |
|---|---|---|
| bigint | Native | bigint |
| decfloat | Extended | <<decfloat>> |
| decimal | Native | decimal |
| double | Native | double |
| integer | Native | integer |
| numeric | Native | numeric (db2i) |
| real | Native | real |
| smallint | Native | smallint |
| date | Native | ansidate |
| time | Native | time2 |
| timestamp | Native | timestamp |
| char | Native | char |
| clob | Native | clob |
| varchar | Native | varchar |
| binary | Native | binary |
| blob | Native | blob |
| varbinary | Native | varbinary |
| datalink | Extended | <<datalink>> |
| xml | Extended | <<xml>> |
| rowid | Extended | <<rowid>> |
| dbclob | Native | clob |
| graphic | Native | nchar |
| vargraphic | Native | nvarchar |
| user defined | Extended | <<user defined>> |
| Data Type | HVR Capture Support | HVR Catalog Data Type |
|---|---|---|
| bigint | Native | integer8 |
| decimal | Native | decimal |
| float | Native | float8 |
| float4 | Native | float4 |
| float8 | Native | float8 |
| integer | Native | integer4 |
| integer1 | Native | integer1 |
| integer2 | Native | integer2 |
| integer4 | Native | integer4 |
| integer8 | Native | integer8 |
| real | Native | float4 |
| smallint | Native | integer2 |
| tinyint | Native | integer1 |
| ansidate | Native | ansidate |
| ingresdate | Native | ingresdate |
| interval day to second | Native | interval day to second (ingres) |
| interval year to month | Native | interval year to month (ingres) |
| time with local time zone | Native | time with local time zone |
| time with time zone | Native | time with time zone |
| time without time zone | Native | time |
| timestamp with local timezone | Native | timestamp with local timezone |
| timestamp with time zone | Native | timestamp with time zone |
| timestamp without time zone | Native | timestamp (ingres) |
| c | Native | c |
| char | Native | char |
| clob | Native | long varchar |
| long nvarchar | Native | long nvarchar |
| long varchar | Native | long varchar |
| nchar | Native | nchar |
| nclob | Native | long nvarchar |
| nvarchar | Native | nvarchar |
| text | Native | text (ingres) |
| varchar | Native | varchar |
| ipv4 | Extended | <<ipv4>> |
| ipv6 | Extended | <<ipv6>> |
| logical_key | Extended | <<logical_key>> |
| money | Native | money (ingres) |
| uuid | Extended | <<uuid>> |
| byte | Native | byte |
| byte varying / varbyte | Native | byte varying |
| long byte | Native | long byte |
| boolean | Native | boolean |
| circularstring | Extended | <<circularstring>> |
| compoundcurve | Extended | <<compoundcurve>> |
| curvepolygon | Extended | <<curvepolygon>> |
| geometry | Extended | <<geometry>> |
| geometrycollection | Extended | <<geometrycollection>> |
| linestring | Extended | <<linestring>> |
| multicurve | Extended | <<multicurve>> |
| multilinestring | Extended | <<multilinestring>> |
| multipoint | Extended | <<multipoint>> |
| multipolygon | Extended | <<multipolygon>> |
| multisurface | Extended | <<multisurface>> |
| point | Extended | <<point>> |
| polygon | Extended | <<polygon>> |
| polyhedralsurface | Extended | <<polyhedralsurface>> |
| tin | Extended | <<tin>> |
| triangle | Extended | <<triangle>> |
| Data Type | HVR Capture Support | HVR Catalog Data Type |
|---|---|---|
| bigint | Native | bigint |
| bigint unsigned | Native | bigint unsigned |
| bit | Native | bit (mysql) |
| bool | Native | tinyint signed |
| boolean | Native | tinyint signed |
| dec | Native | decimal |
| decimal | Native | decimal |
| decimal unsigned | Native | decimal |
| double | Native | double |
| double precision | Native | double |
| double unsigned | Native | double |
| fixed | Native | decimal |
| float | Native | real |
| float unsigned | Native | real |
| int | Native | int |
| int unsigned | Native | int unsigned |
| integer | Native | int |
| mediumint | Native | mediumint |
| mediumint unsigned | Native | mediumint unsigned |
| numeric | Native | decimal |
| real | Native | double |
| smallint | Native | smallint |
| smallint unsigned | Native | smallint unsigned |
| tinyint | Native | tinyint signed |
| date | Native | ansidate |
| datetime | Native | datetime (mysql) |
| time | Native | time (mysql) |
| timestamp | Native | timestamp (mysql) |
| year | Native | smallint |
| binary | Native | binary |
| blob | Native | varbinary(max) |
| char | Native | char |
| char byte | Native | binary |
| json | Native | varchar(max) |
| longblob | Native | varbinary(max) |
| longtext | Native | varchar(max) |
| mediumblob | Native | varbinary(max) |
| mediumtext | Native | varchar(max) |
| text | Native | varchar(max) |
| tinyblob | Native | varbinary(max) |
| tinytext | Native | varchar(max) |
| varbinary | Native | varbinary |
| varchar | Native | varchar |
| geometry | Extended | <<geometry>> |
| geometrycollection | Extended | <<geometrycollection>> |
| linestring | Extended | <<linestring>> |
| multilinestring | Extended | <<multilinestring>> |
| multipoint | Extended | <<multipoint>> |
| multipolygon | Extended | <<multipolygon>> |
| point | Extended | <<point>> |
| polygon | Extended | <<polygon>> |
| Data Type | HVR Capture Support | HVR Catalog Data Type |
|---|---|---|
| bigint | Native | bigint |
| bigint unsigned | Native | bigint unsigned |
| bit | Native | bit (mysql) |
| bool | Native | tinyint signed |
| boolean | Native | tinyint signed |
| dec | Native | decimal |
| dec unsigned | Native | decimal |
| decimal | Native | decimal |
| decimal unsigned | Native | decimal |
| double | Native | double |
| double precision | Native | double |
| double precision unsigned | Native | double |
| double unsigned | Native | double |
| fixed | Native | decimal |
| fixed unsigned | Native | decimal |
| float | Native | real |
| float unsigned | Native | real |
| int | Native | int |
| int unsigned | Native | int unsigned |
| integer | Native | int |
| integer unsigned | Native | int unsigned |
| mediumint | Native | mediumint |
| mediumint unsigned | Native | mediumint unsigned |
| numeric | Native | decimal |
| numeric unsigned | Native | decimal |
| real | Native | double |
| real unsigned | Native | double |
| smallint | Native | smallint |
| smallint unsigned | Native | smallint unsigned |
| tinyint | Native | tinyint signed |
| tinyint unsigned | Native | tinyint unsigned |
| date | Native | ansidate |
| datetime | Native | datetime (mysql) |
| time | Native | time (mysql) |
| timestamp | Native | timestamp (mysql) |
| year | Native | smallint |
| binary | Native | binary |
| blob | Native | varbinary(max) |
| char | Native | char |
| long varchar | Native | varchar(max) |
| longblob | Native | varbinary(max) |
| longtext | Native | varchar(max) |
| mediumblob | Native | varbinary(max) |
| mediumtext | Native | varchar(max) |
| long | Native | varchar(max) |
| text | Native | varchar(max) |
| tinyblob | Native | varbinary(max) |
| tinytext | Native | varchar(max) |
| varbinary | Native | varbinary |
| varchar | Native | varchar |
| enum | Extended | <<enum>> |
| set | Extended | <<set>> |
| geometry | Extended | <<geometry>> |
| geometrycollection | Extended | <<geometrycollection>> |
| linestring | Extended | <<linestring>> |
| multilinestring | Extended | <<multilinestring>> |
| multipoint | Extended | <<multipoint>> |
| multipolygon | Extended | <<multipolygon>> |
| point | Extended | <<point>> |
| polygon | Extended | <<polygon>> |
| json | Extended | <<json>> |
| Data Type | HVR Capture Support | HVR Catalog Data Type |
|---|---|---|
| binary_double | Native | binary_double |
| binary_float | Native | binary_float |
| float | Native | number |
| long | Native | long |
| number | Native | number |
| date | Native | date |
| interval day to second | Native | interval day to second |
| interval year to month | Native | interval year to month |
| timestamp | Native | timestamp (oracle) |
| timestamp with local time zone | Native | timestamp with local tz (oracle) |
| timestamp with time zone | Native | timestamp with tz (oracle) |
| char | Native | char (oracle) |
| nchar | Native | nchar (oracle) |
| nvarchar2 | Native | nvarchar2 |
| varchar | Native | varchar2 |
| varchar2 | Native | varchar2 |
| long raw | Native | long raw |
| raw | Native | raw |
| bfile | Native | bfile |
| blob | Native | blob |
| clob | Native | clob |
| nclob | Native | nclob |
| rowid | Native | rowid |
| urowid | Native | urowid |
| extended data types | Extended | <<data type>> |
| ref | Extended | <<data type>> |
| varrays | Extended | <<data type>> |
| nested tables | Extended | <<data type>> |
| anytype | Extended | <<data type>> |
| anydata | Extended | <<data type>> |
| anydataset | Extended | <<data type>> |
| uri | Extended | <<data type>> |
| xmltype | Extended | <<xmltype>> |
| sdo_geometry | Extended | <<data type>> |
| sdo_georaster | Extended | <<data type>> |
| sdo_topo_geometry | Extended | <<data type>> |
| media | Extended | <<data type>> |
| Data Type | HVR Capture Support | HVR Catalog Data Type |
|---|---|---|
| smallint | Native | smallint |
| integer | Native | integer |
| int | Native | integer |
| bigint | Native | bigint |
| int2 | Native | smallint |
| int4 | Native | integer |
| int8 | Native | bigint |
| decimal | Native | number |
| numeric | Native | number |
| double precision | Native | float |
| real | Native | real |
| smallserial | Native | smallint |
| serial2 | Native | smallint |
| serial | Native | integer |
| bigserial | Native | bigint |
| serial8 | Native | bigint |
| time | Native | time |
| time with time zone | Native | time with time zone |
| timestamp | Native | postgres timestamp |
| timestamp with time zone | Native | postgres timestamp with time zone |
| date | Native | postgres date |
| interval | Extended | <<interval>> |
| char / character | Native | char |
| varchar | Native | varchar or clob (if char length is large) |
| text | Native | clob |
| bytea | Native | blob |
| json | Native | json |
| jsonb | Native | jsonb |
| boolean | Native | boolean |
| money | Extended | <<money>> |
| point | Extended | <<point>> |
| line | Extended | <<line>> |
| lseg | Extended | <<_lseg>> |
| box | Extended | <<_box>> |
| path | Extended | <<path>> |
| polygon | Extended | <<polygon>> |
| circle | Extended | <<circle>> |
| cidr | Extended | <<cidr>> |
| inet | Extended | <<inet>> |
| macaddr | Extended | <<macaddr>> |
| macaddr8 | Extended | <<macaddr8>> |
| bit | Extended | <<bit>> |
| bit varying / varbit | Extended | <<varbit>> |
| tsvector | Extended | <<tsvector>> |
| tsquery | Extended | <<tsquery>> |
| uuid | Native1 | uniqueidentifier1 |
| xml | Extended | <<xml>> |
| int4range | Extended | <<int4range>> |
| int8range | Extended | <<int8range>> |
| numrange | Extended | <<numrange>> |
| tsrange | Extended | <<tsrange>> |
| tstzrange | Extended | <<tstzrange>> |
| daterange | Extended | <<daterange>> |
| oid | Extended | <<oid>> |
| pg_lsn | Extended | <<pg_lsn |
| domain | Extended | <<domain>> |
| user defined | Extended | <<user defined>> |
| 1 - Since HVR 5.7.5/2 and 5.7.0/12, the 'uuid' data type is supported as 'Native' and is mapped to the HVR Catalog Type 'uniqueidentifier'. |
| Data Type | HVR Capture Support | HVR Catalog Data Type |
|---|---|---|
| int | Native | int |
| bigint | Native | bigint |
| smallint | Native | smallint |
| tinyint | Native | tinyint |
| numeric | Native | numeric |
| decimal | Native | numeric |
| bit | Native | bit |
| money | Native | money |
| smallmoney | Native | smallmoney |
| float | Native | float |
| real | Native | real |
| date | Native | ansidate |
| datetime | Native | datetime |
| datetime2 | Native | datetime(2) |
| datetimeoffset | Native | datetimeoffset |
| smalldatetime | Native | smalldatetime |
| time | Native | time |
| char | Native | char |
| varchar | Native | varchar |
| text | Native | text (sqlserver) |
| nchar | Native | nchar |
| nvarchar | Native | nvarchar |
| ntext | Native | ntext |
| binary | Native | binary |
| varbinary | Native | varbinary |
| image | Native | image |
| uniqueidentifier | Native | uniqueidentifier |
| xml | Native | xml |
| cursor | Extended | <<cursor>> |
| hierarchyid | Extended | <<hierarchyid>> |
| rowversion | Extended | <<rowversion>> |
| sql_variant | Extended | <<sql_variant>> |
| spatial geometry types | Extended | <<geometry>> |
| spatial geography types | Extended | <<geography>> |
| table | Extended | <<table>> |
| HVR Catalog Data Types | Attributes | Aurora MySQL (UTF-8) | Aurora PostgreSQL (UTF-8) | Avro 1.6 | Avro 1.8 | Azure Synapse Analytics | 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=10 encoding=UTF-8 |
char(10) charset utf8mb4 | char(10) | char(10) | char(10) | char(10) | char(10) | char(10) | char(10) | char(10) | char(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=10 encoding=UTF-8 |
char(10) charset utf8mb4 | char(10) | char(10) | char(10) | char(10) | char(10) | char(10) | char(10) | char(10) | char(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=4000 encoding=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=8000 encoding=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=40 charlen=10 encoding=UTF-8 |
char(10) charset utf8mb4 | char(10) | char(10) | char(10) | char(10) | char(10) | char(40) | char(10) | char(10) | char(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=10 encoding=WINDOWS-1252 |
char(10) charset latin1 | char(10) | char(10) | char(10) | char(10) | char(10) | char(20) | char(10) | char(10) | char(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=10 encoding=UTF-8 |
char(10) charset utf8mb4 | char(10) | char(10) | char(10) | char(10) | char(10) | char(10) | char(10) | char(10) | char(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=2000 encoding=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=40 charlen=10 encoding=UTF-8 |
char(10) charset utf8mb4 | char(10) | char(10) | char(10) | char(10) | char(10) | char(40) | char(10) | char(10) | char(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=10 encoding=WINDOWS-1252 |
char(10) charset latin1 | char(10) | char(10) | char(10) | char(10) | char(10) | char(20) | char(10) | char(10) | char(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=10 scale=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=10 scale=-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=10 scale=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=10 scale=3 |
decimal(10,3) | numeric(10,3) | varchar(12) | decimal(10,3) | numeric(10,3) | numeric(10,3) | decimal(10,3) | numeric(10,3) | 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=10 scale=3 |
decimal(10,3) | numeric(10,3) | varchar(12) | decimal(10,3) | numeric(10,3) | numeric(10,3) | decimal(10,3) | numeric(10,3) | 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=10 encoding=UTF-8 |
varchar(10) charset utf8mb4 | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(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) | uuid | 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) | uuid | 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=10 encoding=UTF-8 |
varchar(10) charset utf8mb4 | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(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=8000 encoding=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=40 charlen=10 encoding=UTF-8 |
varchar(10) charset utf8mb4 | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(40) | varchar(10) | varchar(10) | varchar(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=10 encoding=WINDOWS-1252 |
varchar(10) charset latin1 | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(20) | varchar(10) | varchar(10) | varchar(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=10 encoding=UTF-8 |
varchar(10) charset utf8mb4 | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(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=8000 encoding=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=40 charlen=10 encoding=UTF-8 |
varchar(10) charset utf8mb4 | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(40) | varchar(10) | varchar(10) | varchar(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=10 encoding=WINDOWS-1252 |
varchar(10) charset latin1 | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(20) | varchar(10) | varchar(10) | varchar(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=10 encoding=UTF-8 |
varchar(10) charset utf8mb4 | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(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=40 charlen=10 encoding=UTF-8 |
varchar(10) charset utf8mb4 | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(40) | varchar(10) | varchar(10) | varchar(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=10 encoding=WINDOWS-1252 |
varchar(10) charset latin1 | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(10) | varchar(20) | varchar(10) | varchar(10) | varchar(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) |