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 |
|