The following table lists the default forward data type mappings for ODBC 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| SQL_BIGINT | - | - | - | - | - | - | BIGINT | 8 | - | - |
| SQL_BINARY | 1 | 254 | - | - | - | - | CHARACTER | - | - | Y |
| SQL_BINARY | 255 | 32672 | - | - | - | - | VARCHAR | - | - | Y |
| SQL_BIT | - | - | - | - | - | - | SMALLINT | 2 | - | - |
| SQL_CHAR | 1 | 254 | - | - | - | - | CHAR | - | - | N |
| SQL_CHAR | 255 | 32672 | - | - | - | - | VARCHAR | - | - | N |
| SQL_DATE | - | - | - | - | - | - | DATE | - | - | - |
| SQL_DATE | - | - | - | - | - | - | TIMESTAMP1 | - | - | - |
| SQL_DECIMAL | 1 | 31 | 0 | 31 | - | - | DECIMAL | - | - | - |
| SQL_DECIMAL | 32 | 38 | 0 | 38 | - | - | DOUBLE | 8 | - | - |
| SQL_DOUBLE | - | - | - | - | - | - | DOUBLE | 8 | - | - |
| SQL_FLOAT | - | 8 | - | - | - | - | FLOAT | 8 | - | - |
| SQL_FLOAT | - | 4 | - | - | - | - | FLOAT | 4 | - | - |
| SQL_INTEGER | - | - | - | - | - | - | INTEGER | 4 | - | - |
| SQL_ LONGVARCHAR | - | - | - | - | - | - | CLOB | 2147483647 | - | N |
| SQL_ LONGVARBINARY | - | - | - | - | - | - | BLOB | 2147483647 | - | Y |
| SQL_NUMERIC | 1 | 31 | 0 | 31 | - | - | DECIMAL | - | - | - |
| SQL_NUMERIC | 32 | 32 | 0 | 31 | - | - | DOUBLE | 8 | - | - |
| SQL_REAL | - | - | - | - | - | - | REAL | 4 | - | - |
| SQL_SMALLINT | - | - | - | - | - | - | SMALLINT | 2 | - | - |
| SQL_TIMESTAMP | - | - | - | - | - | - | TIMESTAMP(6) | 10 | 6 | - |
| SQL_TIMESTAMP(p) | - | - | - | - | - | - | TIMESTAMP(6) | 10 | 6 | - |
| SQL_TYPE_DATE | - | - | - | - | - | - | DATE | 4 | - | - |
| SQL_TYPE_TIME | - | - | - | - | - | - | TIME | 3 | - | - |
| SQL_TYPE_ TIMESTAMP | - | - | - | - | - | - | TIMESTAMP | 10 | - | - |
| SQL_TINYINT | - | - | - | - | - | - | SMALLINT | 2 | - | - |
| SQL_VARBINARY | 1 | 32672 | - | - | - | - | VARCHAR | - | - | Y |
| SQL_VARCHAR | 1 | 32672 | - | - | - | - | VARCHAR | - | - | N |
| SQL_WCHAR | 1 | 127 | - | - | - | - | CHAR | - | - | N |
| SQL_WCHAR | 128 | 16336 | - | - | - | - | VARCHAR | - | - | N |
| SQL_WVARCHAR | 1 | 16336 | - | - | - | - | VARCHAR | - | - | N |
| SQL_ WLONGVARCHAR | - | 1073741823 | - | - | - | - | CLOB | 2147483647 | - | N |
Note:
|
||||||||||