The following table contains the available data types for Oracle databases supported by CONNX.
|
CONNX Data Type |
SQL Data Type |
Length |
VMS Equivalent |
Description |
|
Big Double Text |
CHAR |
48 |
|
Oracle Large Number (38) |
|
Binary (Text) |
CHAR |
1-30000 |
Maxcim RFA Maxcim Byte Array |
The binary field is not converted. It provides access to raw, unaltered data in an RMS file. |
|
BLOB |
LONG VARBINARY |
0-2147483000 |
|
Binary Large Object |
|
CLOB |
LONG VARCHAR |
0-2147483000 |
|
Character Large Object |
|
Oracle Date |
TIMESTAMP |
16 |
|
Oracle Date |
|
Oracle MLSLABEL |
BINARY |
1-19 |
|
Oracle MLSLABEL |
|
Oracle Rowid |
BINARY |
16 |
|
Oracle Rowid |
|
Oracle Timestamp |
TIMESTAMP |
-1 |
|
|
|
Text (Right Space Padded) |
CHAR |
1-30000 |
Text Maxcim Yes/No |
Alphanumeric and symbols. (1-30000 chars); same as Text but with right space padding. |
|
Text Space Padded (no nulls) |
CHAR |
-1 |
|
|
|
Varbinary |
VARBINARY |
-1 |
|
|