Supported JDBC-compliant Data Types
Describes the JDBC-compliant data types supported in Integration.
Integration only supports a subset of the JDBC-compliant data types. Those data types not supported are not reported back to the server during the import structure process.
The JDBC drivers map the underlying data types to a JDBC type, so to understand what DBMS types are supported, you need to consult documentation for the specific DBMS. This section contains the supported data types for general JDBC-compliant databases, Oracle, SQL Server, and H2 databases.
Supported JDBC data types
| JDBC TYPE | DISCOVERY TYPE |
|---|---|
| CHAR | STRING |
| VARCHAR | STRING |
| LONGVARCHAR | STRING |
| BIT | BOOLEAN |
| BOOLEAN | BOOLEAN |
| TINYINT | LONG |
| SMALLINT | LONG |
| INTEGER | LONG |
| BIGINT | LONG |
| REAL | DOUBLE |
| DOUBLE | DOUBLE |
| FLOAT | DOUBLE |
| DATE | DATE |
| TIME | DATE |
| TIMESTAMP | DATE |
The following JDBC types are not supported: BINARY, VARBINARY, LONGVARBINARY, DECIMAL, and NUMERIC.
Supported MS SQL Server data types
| SQL Server | JDBC | Support |
|---|---|---|
| bigint | BIGINT | Y |
| bit | BIT | Y |
| decimal | DECIMAL | N |
| int | INTEGER | Y |
| money | DECIMAL | N |
| numeric | NUMERIC | N |
| smallint | SMALLINT | Y |
| smallmoney | DECIMAL | N |
| tinyint | TINYINT | Y |
| float | DOUBLE | Y |
| real | REAL | Y |
| date | VARCHAR | Y |
| datetime2 | VARCHAR | Y |
| datetime | TIMESTAMP | Y |
| datetimeoffset | VARCHAR | Y |
| smalldatetime | TIMESTAMP | Y |
| time | VARCHAR | Y |
| char | CHAR | Y |
| varchar | VARCHAR | Y |
| text | CLOB | N |
| nchar | CHAR | Y |
| nvarchar | CLOB | N |
| ntext | CLOB | N |
| binary | BINARY | N |
| image | BLOB | N |
| hierarchyid | BLOB | N |
| sql_variant | VARCHAR | Y |
| timestamp | BINARY | N |
| uniqueidentifier | CHAR | Y |
| xml | CLOB | N |
Supported Oracle data types
| SQL Server | JDBC | Support |
|---|---|---|
| CHAR | CHAR | Y |
| VARCHAR2 | VARCHAR | Y |
| NCHAR | OTHER | N |
| NVARCHAR2 | OTHER | N |
| NUMBER | DECIMAL | N |
| FLOAT | FLOAT | Y |
| BINARY_FLOW | ?100 | N |
| BINARY_DOUBLE | ?101 | N |
| RAW | VARBINARY | N |
| DATE | TIMESTAMP | Y |
| TIMESTAMP | TIMESTAMP | Y |
| INTERVAL_YEAR_TO_MONTH | ?-103 | N |
| INTERVAL_DAY_TO_SECOND | ?-104 | N |
| BLOB | BLOB | N |
| CLOB | CLOB | N |
| NCLOB | OTHER | N |
| BFILE | ?-13 | N |
| CHARACTER | CHAR | Y |
| VARCHAR | VARCHAR | Y |
| NATIONAL_CHARACTER | OTHER | N |
| NATIONAL_CHAR | OTHER | N |
| NUMERIC | DECIMAL | N |
| DECIMAL | DECIMAL | N |
| DEC | DECIMAL | N |
| INTEGER | DECIMAL | N |
| INT | DECIMAL | N |
| SMALLINT | DECIMAL | N |
| DOUBLE_PRECISION | FLOAT | Y |
| REAL | FLOAT | Y |
Supported H2 data types
| SQL Server | JDBC | Support |
|---|---|---|
| INT | INTEGER | Y |
| INTEGER | INTEGER | Y |
| MEDIUMINT | INTEGER | Y |
| INT4 | INTEGER | Y |
| SIGNED | INTEGER | Y |
| BOOLEAN | BOOLEAN | Y |
| BIT | BOOLEAN | Y |
| BOOL | BOOLEAN | Y |
| TINYINT | TINYINT | Y |
| SMALLINT | SMALLINT | Y |
| INT2 | SMALLINT | Y |
| YEAR | SMALLINT | Y |
| BIGINT | BIGINT | Y |
| IDENTITY | BIGINT | Y |
| DECIMAL | DECIMAL | N |
| NUMBER | DECIMAL | N |
| DEC | DECIMAL | N |
| NUMERIC | DECIMAL | N |
| DOUBLE | DOUBLE | Y |
| FLOAT | DOUBLE | Y |
| FLOAT4 | REAL | Y |
| FLOAT8 | DOUBLE | Y |
| REAL | REAL | Y |
| TIME | TIME | Y |
| DATE | DATE | Y |
| TIMESTAMP | TIMESTAMP | Y |
| DATETIME | TIMESTAMP | Y |
| SMALLDATETIME | TIMESTAMP | Y |
| BINARY | VARBINARY | N |
| VARBINARY | VARBINARY | N |
| LONGVARBINARY | VARBINARY | N |
| RAW | VARBINARY | N |
| BYTEA | VARBINARY | N |
| OTHER | OTHER | N |
| VARCHAR | VARCHAR | Y |
| LONGVARCHAR | VARCHAR | Y |
| VARCHAR2 | VARCHAR | Y |
| NVARCHAR | VARCHAR | Y |
| NVARCHAR2 | VARCHAR | Y |
| VARCHAR_CASESENSTIVE | VARCHAR | Y |
| VARCHAR_IGNORECASE | VARCHAR | Y |
| CHAR | CHAR | Y |
| CHARACTER | CHAR | Y |
| NCHAR | CHAR | Y |
| BLOB | BLOB | N |
| TINYBLOB | BLOB | N |
| MEDIUMBLOB | BLOB | N |
| LONGBLOB | BLOB | N |
| IMAGE | BLOB | N |
| OID | BLOB | N |
| CLOB | CLOB | N |