|
<< Click to Display Table of Contents >> dBASE 2019 SQL data type translation |
  
|
|
<< Click to Display Table of Contents >> dBASE 2019 SQL data type translation |
|
The dBASE 2019, as tested using BDE connection just like PdxEditor, translates SQL field types almost like the standard BDE translation, the small differences not compromising data handling capacity of the fields translated.
Compared to PdxEditor/standard BDE applications the dBASE 2019 is however slightly more restrictive in the following ways:
•Rejecting DECIMAL without sizing parameter also for dBASE tables.
•Rejects NUMERIC and FLOAT without sizing parameter for any both Paradox and dBASE tables of any level.
•Rejects MONEY for dBASE tables level III+, IV and 5.
Also, the dBASE 2019 does not create FoxPro tables, irrespective of the currently active alias database connection being defined as a FoxPro database and the BDE setting with FoxPro as the default data format. Tables created by SQL are instead created according to the current dBASE driver settings.
Paradox version |
dBASE version |
|||||||
SQL |
3.5 |
4 |
5 |
7 |
III+ |
IV |
5 |
7 |
SMALLINT |
Short |
Short |
Short |
Short |
Numeric(11,0) |
Numeric(11,0) |
Numeric(11,0) |
Long |
INTEGER |
N/A |
N/A |
Long |
Long |
Numeric(11,0) |
Numeric(11,0) |
Numeric(11,0) |
Long |
FLOAT |
Number |
Number |
Number |
Number |
Err |
Err |
Err |
Err |
FLOAT(4) |
Number |
Number |
Number |
Number |
Numeric(4,0) |
Numeric(4,0) |
Numeric(4,0) |
Double |
FLOAT(5) |
Number |
Number |
Number |
Number |
Numeric(5,0) |
Numeric(5,0) |
Numeric(5,0) |
Double |
FLOAT(7,2) |
Number |
Number |
Number |
Number |
Numeric(7,2) |
Numeric(7,2) |
Numeric(7,2) |
Double |
FLOAT(20,18) |
Number |
Number |
Number |
Number |
Err |
Numeric(20,18) |
Numeric(20,18) |
Double |
DECIMAL |
Err |
Err |
Err |
Err |
Err |
Err |
Err |
Err |
DECIMAL(4) |
N/A |
N/A |
BCD(32,0) |
BCD(32,0) |
Numeric(4,0) |
Numeric(4,0) |
Numeric(4,0) |
Numeric(4,0) |
DECIMAL(5) |
N/A |
N/A |
BCD(32,0) |
BCD(32,0) |
Numeric(5,0) |
Numeric(5,0) |
Numeric(5,0) |
Numeric(5,0) |
DECIMAL(7,2) |
N/A |
N/A |
BCD(32,2) |
BCD(32,2) |
Numeric(7,2) |
Numeric(7,2) |
Numeric(7,2) |
Numeric(7,2) |
DECIMAL(20,18) |
N/A |
N/A |
BCD(32,18) |
BCD(32,18) |
Err |
Numeric(20,18) |
Numeric(20,18) |
Numeric(20,18) |
NUMERIC |
Number |
Number |
Number |
Number |
Err |
Err |
Err |
Err |
NUMERIC(4) |
Number |
Number |
Number |
Number |
Numeric(4,0) |
Numeric(4,0) |
Numeric(4,0) |
Numeric(4,0) |
NUMERIC(5) |
Number |
Number |
Number |
Number |
Numeric(5,0) |
Numeric(5,0) |
Numeric(5,0) |
Numeric(5,0) |
NUMERIC(7,2) |
Number |
Number |
Number |
Number |
Numeric(7,2) |
Numeric(7,2) |
Numeric(7,2) |
Numeric(7,2) |
NUMERIC(20,18) |
Number |
Number |
Number |
Number |
Err |
Numeric(20,18) |
Numeric(20,18) |
Numeric(20,18) |
CHARACTER(10) |
Alpha(10) |
Alpha(10) |
Alpha(10) |
Alpha(10) |
Character(10) |
Character(10) |
Character(10) |
Character(10) |
VARCHAR(10) |
Alpha(10) |
Alpha(10) |
Alpha(10) |
Alpha(10) |
Character(10) |
Character(10) |
Character(10) |
Character(10) |
DATE |
Date |
Date |
Date |
Date |
Date |
Date |
Date |
Date |
BOOLEAN |
N/A |
N/A |
Logical |
Logical |
Logical |
Logical |
Logical |
Logical |
BLOB(1,1) |
N/A |
Memo |
Memo |
Memo |
Memo |
Memo |
Memo |
Memo |
BLOB(1,2) |
N/A |
Binary |
Binary |
Binary |
Memo |
Memo |
Binary |
Binary |
BLOB(1,3) |
N/A |
Formatted Memo |
Formatted Memo |
Formatted Memo |
Memo |
Memo |
Memo |
Memo |
BLOB(1,4) |
N/A |
OLE |
OLE |
OLE |
Memo |
Memo |
OLE |
OLE |
BLOB(1,5) |
N/A |
Graphic |
Graphic |
Graphic |
Memo |
Memo |
Binary |
Binary |
TIME |
N/A |
N/A |
Time |
Time |
Character(8) |
Character(8) |
Character(8) |
Character(8) |
TIMESTAMP |
N/A |
N/A |
TimeStamp |
TimeStamp |
Character(30) |
Character(30) |
Character(30) |
DateTime |
MONEY |
Money |
Money |
Money |
Money |
Err |
Err |
Err |
Numeric(20,18) |
AUTOINC |
N/A |
N/A |
Autoincrement |
Autoincrement |
Numeric(11) |
Numeric(11) |
Numeric(11) |
Autoinc |
BYTES |
N/A |
N/A |
Bytes(1) |
Bytes(1) |
Err |
Err |
Err |
Err |
BYTES(10) |
N/A |
N/A |
Bytes(10) |
Bytes(10) |
Err |
Err |
Err |
Err |
Type translations marked as Err denotes that the SQL keyword or keyword w. parameters is incompatible with SQL execution for that table type.
__________________________