RAW/LONG Type Mapping

TimesTen does not support the data types RAW, LONG, and LONG RAW. However, the TimesTen data types VARCHAR2 and VARBINARY are very similar and can often be used instead.

Type mapping applies to Oracle database columns of type RAW(n), LONG, and LONG RAW and is controlled by the rawlong field in the -typeMap command-line option. The rawlong field accepts a value of 0 or 1, as follows:

Values Description

Values	Description
`0`	No mapping applies; `RAW`, `LONG`, and `LONG RAW` are unsupported data types. The columns do not appear in the TimesTen tables. `-onBadType` option determines whether the utility stops, skips the affected table, or omits the unsupported column. For more details on this option, see Command Syntax and Option Descriptions.
`1`	This is the default value. Columns are mapped as follows: `RAW(n)` to `VARBINARY(n)` `LONG` to `VARCHAR2(4194304)` `LONG RAW` to `VARBINARY(4194304)` In addition, for any `RAW(n)` columns mapped to `VARBINARY(n)`, variable length type optimization is then applied if `var=1`. The `ttLoadFromOracle()` built-in procedure can load data into columns mapped in this way (provided that the actual data length in Oracle does not exceed the 4 MB maximum supported by TimesTen variable-length data types).

0

No mapping applies; RAW, LONG, and LONG RAW are unsupported data types. The columns do not appear in the TimesTen tables.

-onBadType option determines whether the utility stops, skips the affected table, or omits the unsupported column. For more details on this option, see Command Syntax and Option Descriptions.

1

This is the default value. Columns are mapped as follows:

RAW(n) to VARBINARY(n)
LONG to VARCHAR2(4194304)
LONG RAW to VARBINARY(4194304)

In addition, for any RAW(n) columns mapped to VARBINARY(n), variable length type optimization is then applied if var=1.

The ttLoadFromOracle() built-in procedure can load data into columns mapped in this way (provided that the actual data length in Oracle does not exceed the 4 MB maximum supported by TimesTen variable-length data types).