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

CONNX Data Type | SQL Data Type | Length | VMS Equivalent Data Type | Description
Binary | CHAR | 8 |  | This date should not be used. It is here for backward compatibility. See VMS DATE/Time. This converts a VMS date into a 23-character string.
Binary (Text) | CHAR | -1 |  |
Double | DOUBLE | 8 | VMS Double Real Maxcim Double Real | Double precision floating point (8 bytes).
Left Separate -> Decimal | DECIMAL | -1 |  |
Left Separate -> Double | DOUBLE | 1-20 | Left Separate | Left Separate Double
Left Separate -> Integer | LONG | 1-20 | Left Separate | Left Separate Integer
Longword | INTEGER | 4 |  |
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 |  |
Quadword -> Char | VARCHAR | 8 |  |
Quadword -> Char(DP) | VARCHAR | 8 |  |
Quadword Decimal | CHAR | 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.
Signed Overpunch -> Decimal | DECIMAL | -1 |  |
Signed Overpunch -> Double | DOUBLE | -1 |  |
Single | REAL | 4 | VMS Single Real Maxcim Single Real | Single precision floating point (4 bytes).
Text (Expandable) | VARCHAR | 1-30000 |  | Alphanumeric and symbols. (1-30000 chars).
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 Double -> Currency | DECIMAL | 8 |  |
VMS G Float | DOUBLE | 8 |  |
Word | SMALLINT | 2 |  |
Word -> Float | REAL | 2 |  |
Word Double (2) | DOUBLE | 2 |  | Word converted to double with implied decimal point.
Word Numeric -> Decimal | DECIMAL | 2 |  |