DataFlex/PowerFlex Data Types
The following table contains the available data types for DataFlex/PowerFlex databases supported by CONNX.

DataFlex Data Type | SQL Data Type | Length | Description
Binary (Text) | CHAR | -1 |
Flex Binary | Binary | 1-32000 | Binary value
Flex Date | DATE | 10 | Date in ODBC format. DataFlex date can be in the MM/DD/YY or MM/DD/YYYY format.
Flex Double | DOUBLE | TSZ |
Flex Longword | INTEGER | TSZ |
Flex Text | CHAR | 1-32000 | Alphanumeric and symbols (1-32000 chars).
Flex Numeric | DECIMAL | -1 | Dataflex numeric to SQL Decimal
Text -> Currency | CURRENCY | -1 |
Text (Right Space Padded) | CHAR | -1 |