The table show how SQL data types maps to DataFlex native types and the capacity of each type. The capacity shown is the highest possible value for the DataFlex side - or if the SQL side max value is lower - the SQL side capacity that is shown. Mostly it is the DataFlex side that has the lower capacity value.
|
SQL Type Name |
SQL Type Constant |
DataFlex Type |
DataFlex Type Constant |
Capacity |
|
|
|
|
|
|
|
BLOB |
eOracle_BLOB |
Binary |
DF_BINARY |
16384 |
|
BINARY_FLOAT |
|
Binary |
DF_BINARY |
16384 |
|
BINARY_DOUBLE |
|
Binary |
DF_BINARY |
16384 |
|
CHAR |
eOracle_CHAR |
Text |
DF_TEXT |
2000 |
|
CLOB |
eOracle_CLOB |
Text |
DF_TEXT |
16384 |
|
DATE |
eOracle_DATE |
Date |
DF_DATE |
6.0 |
|
FLOAT |
eOracle_FLOAT |
Numeric |
DF_BCD |
14.8 |
|
INT |
eOracle_INT |
Numeric |
DF_BCD |
14.0 |
|
INTERVALDAYTOSEC |
eOracle_INTERVALDS |
DateTime |
DF_DATETIME |
23.0 |
|
INTERVALYEARTOMON |
eOracle_INTERVALYM |
DateTime |
DF_DATETIME |
23.0 |
|
LONG |
eOracle_RAW |
Binary |
DF_BINARY |
16384 |
|
LONG RAW |
eOracle_LONGRAW |
Binary |
DF_BINARY |
16384 |
|
NCHAR |
eOracle_NCHAR |
Text |
DF_TEXT |
2000 |
|
NCLOB |
eOracle_NCLOB |
Text |
DF_TEXT |
16384 |
|
NUMBER |
eOracle_NUMBER |
Number |
DF_BCD |
14.8 |
|
NVARCHAR2 |
eOracle_NVARCHAR2 |
Text |
DF_TEXT |
4000 |
|
RAW |
eOracle_RAW |
Binary |
DF_BINARY |
2000 |
|
ROWID |
eOracle_ROWID |
Text |
DF_TEXT |
16384 |
|
TIMESTAMP |
eOracle_TIMESTAMP |
DateTime |
DF_DATETIME |
23.0 |
|
TIMESTAMPLOCALTZ |
eOracle_TIMESTAMPLTZ |
DateTime |
DF_DATETIME |
23.0 |
|
TIMEZONETIMEZONE |
eOracle_TIMESTAMPPTZ |
DateTime |
DF_DATETIME |
23.0 |
|
UROWID |
|
Text |
DF_TEXT |
16384 |
|
VARCHAR2 |
eOracle_VARCHAR2 |
Text |
DF_TEXT |
4000 |