Default forward data type mappings for JDBC data sources
The following table lists the default forward data type mappings for JDBC data sources.
Remote Typename | Remote Lower Len | Remote Upper Len | Remote Lower Scale | Remote Upper Scale | Remote Bit Data | Remote Data Operators | Federated Typename | Federated Length | Federated Scale | Federated Bit Data |
---|---|---|---|---|---|---|---|---|---|---|
BIGINT | - | - | - | - | - | - | BIGINT | 8 | - | - |
BINARY | - | 254 | - | - | - | - | CHAR | - | - | Y |
BINARY | 255 | 32672 | - | - | - | - | VARCHAR | - | - | Y |
BINARY | 32673 | 2147483647 | - | - | - | - | BLOB | 2147483647 | - | - |
BIT | - | - | - | - | - | - | SMALLINT | 2 | - | - |
BLOB | - | - | - | - | - | - | BLOB | 2147483647 | - | - |
BOOLEAN | - | - | - | - | - | - | SMALLINT | 2 | - | - |
CHAR | - | 254 | - | - | - | - | CHAR | - | - | - |
CHAR | 255 | 32672 | - | - | - | - | VARCHAR | - | - | - |
CHAR | 32673 | 2147483647 | - | - | - | - | CLOB | 2147483647 | - | - |
CLOB | - | - | - | - | - | - | CLOB | 2147483647 | - | - |
DATE | - | - | - | - | - | - | DATE | - | - | - |
DATE | - | - | - | - | - | - | TIMESTAMP1 | - | - | - |
DECIMAL | 1 | 31 | 0 | 31 | - | - | DECIMAL | - | - | - |
DECIMAL | 32 | 38 | 0 | 38 | - | - | DOUBLE | 8 | - | - |
DOUBLE | - | - | - | - | - | - | DOUBLE | 8 | - | - |
FLOAT | - | - | - | - | - | - | FLOAT | 4 | - | - |
INTEGER | - | - | - | - | - | - | INTEGER | 4 | - | - |
LONGVARCHAR | - | 32672 | - | - | - | - | VARCHAR | - | - | - |
LONGVARCHAR | 32673 | 2147483647 | - | - | - | - | CLOB | 2147483647 | - | - |
LONGVARBINARY | - | 32672 | - | - | - | - | VARCHAR | - | - | Y |
LONGVARBINARY | 32673 | 2147483647 | - | - | - | - | BLOB | 2147483647 | - | - |
LONGNVARCHAR | - | 16336 | - | - | - | - | VARGRAPHIC | - | - | - |
LONGNVARCHAR2 | 16337 | 1073741823 | - | - | - | - | DBCLOB | - | - | - |
NCHAR2 | - | 127 | - | - | - | - | GRAPHIC | - | - | - |
NCHAR2 | 128 | 16336 | - | - | - | - | VARGRAPHIC | - | - | - |
NCHAR2 | 16337 | 1073741823 | - | - | - | - | DBCLOB | - | - | - |
NCLOB2 | - | - | - | - | - | - | DBCLOB | - | - | - |
NUMERIC | 1 | 31 | 0 | 31 | - | - | DECIMAL | - | - | - |
NUMERIC | 32 | 38 | 0 | 38 | - | - | DOUBLE | 8 | - | - |
NVARCHAR2 | - | 16336 | - | - | - | - | VARGRAPHIC | - | - | - |
NVARCHAR2 | 16337 | 1073741823 | - | - | - | - | DBCLOB | - | - | - |
REAL | REAL | 4 | ||||||||
SMALLINT | - | - | - | - | - | - | SMALLINT | 2 | - | - |
TIME | - | - | - | - | - | - | TIME | 3 | - | - |
TIMESTAMP | - | - | - | - | - | - | TIMESTAMP(6) | 10 | 6 | - |
TIMESTAMP(p) | - | - | - | - | - | - | TIMESTAMP(6) | 10 | 6 | - |
TINYINT | - | - | - | - | - | - | SMALLINT | 2 | - | - |
VARBINARY | - | 32672 | - | - | - | - | VARCHAR | - | - | Y |
VARBINARY | 32673 | 2147483647 | - | - | - | - | BLOB | 2147483647 | - | - |
VARCHAR | - | 32672 | - | - | - | - | VARCHAR | - | - | - |
VARCHAR | 32673 | 2147483647 | - | - | - | - | CLOB | 2147483647 | - | - |
Note:
|
The following data types are unsupported by the JDBC wrapper: DATALINK, OTHER, JAVA_OBJECT, DISTINCT, STRUCT, ARRAY, and REF.