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 |
|
|
|
|
|
|
|
bigint |
eMySQL_LONGLONG |
Numeric |
DF_BCD |
14.0 |
|
bit |
eMySQL_BIT |
ASCII |
DF_ASCII |
4.0 |
|
blob |
eMySQL_BLOB |
Binary |
DF_BINARY |
16384 |
|
char |
eMySQL_STRING |
ASCII |
DF_ASCII |
254 |
|
date |
eMySQL_DATE |
Date |
DF_DATE |
6.0 |
|
datetime |
eMySQL_DATETIME |
DateTime |
DF_DATETIME |
23.0 |
|
decimal |
eMySQL_DECIMAL |
Numeric |
DF_BCD |
14.8 |
|
double |
eMySQL_DOUBLE |
Numeric |
DF_BCD |
14.8 |
|
enum |
eMySQL_ENUM |
ASCII |
DF_ASCII |
254 |
|
float |
eMySQL_FLOAT |
Numeric |
DF_BCD |
14.8 |
|
int |
eMySQL_INT24 |
Numeric |
DF_BCD |
11.0 |
|
longblob |
eMySQL_LONG_BLOB |
Binary |
DF_BINARY |
16384 |
|
longtext |
eMySQL_LONG_TEXT |
Text |
DF_TEXT |
16384 |
|
mediumblob |
eMySQL_MEDIUM_BLOB |
Binary |
DF_BINARY |
16384 |
|
mediumint |
eMySQL_INT24 |
Numeric |
DF_BCD |
9.0 |
|
mediumtext |
eMySQL_MEDIUM_TEXT |
Text |
DF_TEXT |
16384 |
|
set |
eMySQL_SET |
ASCII |
DF_ASCII |
254 |
|
smallint |
eMySQL_SHORT |
Number |
DF_BCD |
6.0 |
|
text |
eMySQL_TEXT |
Text |
DF_TEXT |
16384 |
|
time |
eMySQL_TIME |
ASCII |
DF_ASCII |
10.0 |
|
timestamp |
eMySQL_TIMESTAMP |
DateTime |
DF_DATETIME |
23.0 |
|
tinyblob |
eMySQL_TINY_BLOB |
Binary |
DF_BINARY |
254 |
|
tinyint |
eMySQL_TINY |
Numeric |
DF_BCD |
4.0 |
|
tinytext |
eMySQL_TINY_TEXT |
ASCII |
DF_ASCII |
254 |
|
varchar |
eMySQL_VAR_STRING |
Text |
DF_TEXT |
16384 |
|
year |
eMySQL_YEAR |
Number |
DF_BCD |
4.0 |