Oracle Rdb Data Types
The following table contains the available data types for Oracle Rdb databases supported by CONNX.

CONNX Data Type | SQL Data Type | Length | VMS Equivalent Data Type | Description
Binary | BINARY | 1-30000 | Maxcim RFA Maxcim Byte Array | The binary field is not converted. It provides access to raw, unaltered data in an RMS file.
Binary (Text) | CHAR | -1 |  |
Double | DOUBLE | 8 | Vms Double RealMaxcim Double Real | Double precision floating point (8 bytes)
Interval Date/Day/Second | DOUBLE | -1 |  | Rdb Interval data type
Interval Date Hour | DOUBLE | -1 |  | Rdb Interval data type
Interval Date Hour/Minute | DOUBLE | -1 |  | Rdb Interval data type
Interval Date Hour/Second | DOUBLE | -1 |  | Rdb Interval data type
Interval Date Minute | DOUBLE | -1 |  | Rdb Interval data type
Interval Date Minute/Second | DOUBLE | -1 |  | Rdb Interval data type
Interval Date Month | DOUBLE | -1 |  | Rdb Interval data type
Interval Date Second | DOUBLE | -1 |  | Rdb Interval data type
Interval Date Year | DOUBLE | -1 |  | Rdb Interval data type
Interval Date Year/Month | DOUBLE | -1 |  |
Interval Day | DOUBLE | -1 |  | Rdb Interval data type
Interval Hour | DOUBLE | -1 |  | Rdb Interval data type
Interval Minute | DOUBLE | -1 |  | Rdb Interval data type
Longword -> Decimal | DECIMAL | 4 | VMS Longword Integer with implied decimal PIC S9(X1)V9(X2) COMP where X1 + X2 is between 5 and 9. | Longword Integer with an implied decimal place (4 bytes).
Longword -> Double | DOUBLE | 4 |  |
Longword | INTEGER | 4 | VMS Longword Integer PIC S9(X1) COMP where X1 is between 5 and 9. | Longword Integer (4 bytes)
Quadword -> Char | VARCHAR | 8 |  |
Quadword -> Char(DP) | VARCHAR | 8 |  |
Quadword -> Decimal | DECIMAL | 8 | VMS Quadword Integer with implied decimal PIC S9(X1)V9(X2) COMP where X1+X2 is between 10 and 20. | Quadword Integer with an implied decimal place (8 bytes) converts to a SQL String.
Rdb Date ANSI | DATE | 16 |  |
Rdb Date VMS | TIMESTAMP | 16 |  |
Rdb Date VMS (String) | TIMESTAMP | 16 |  |
Rdb Time | TIME | 16 |  |
Rdb Timestamp | TIMESTAMP | 16 |  |
Signed Overpunch -> Double | DOUBLE | 1 |  |
Single | REAL | 16 |  |
String Tinyint | TINYINT | -1 |  |
String Smallint | SMALLINT | -1 |  |
String Integer | INTEGER | -1 |  |
String Quadword | VARCHAR | -1 |  |
String Single | REAL | -1 |  |
String Double | DOUBLE | -1 |  |
Text (Expandable) | VARCHAR | 1-30000 |  | Alphanumeric and symbols (1-30000 chars).
Text (Null Terminated) | VARCHAR | -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.
VMS Date/Time | TIMESTAMP | 8 |  | VMS Binary Date/Time (8 bytes) converts to an ODBC Timestamp.
VMS G Float | DOUBLE | 8 |  |
Word | SMALLINT | 2 |  |