|
<< Click to Display Table of Contents >> SQL data type translation BDE |
  
|
|
<< Click to Display Table of Contents >> SQL data type translation BDE |
|
Using a common SQL language and data types generating table through the SQL CREATE TABLE TableName (Field Specs); the SQL data types are translated into data types of the target table format and it's version or level choosing target types having the capacity of receiving the data type and sizes specified by the SQL data types.
A number of the data types shown are not available in the early version 3.5 and 4 of the Paradox format.
However, if the current BDE setting for Paradox is set to either of the lower level 3 or 4, SQL translation will just propagate the Paradox table creation to the next level if necessary to comply with the data types of the SQL statement.
BDE Paradox level 3 equals Paradox table version 3.5.
Do note the shift levels and data types from SQL SmallInt and Integer with dBASE level 5 vs. level 7 tables.
Paradox version |
dBASE version |
FoxPro vers. |
|||||||
SQL |
3.5 |
4 |
5 |
7 |
III+ |
IV |
5 |
7 |
2.5 |
SMALLINT |
Short |
Short |
Short |
Short |
Numeric(6,0) |
Numeric(6,0) |
Numeric(6,0) |
Numeric(6,0) |
Numeric(6,0) |
INTEGER |
N/A |
N/A |
Long |
Long |
Numeric(11,0) |
Numeric(11,0) |
Numeric(11,0) |
Long |
Numeric(11,0) |
DECIMAL |
Err |
Err |
Err |
Err |
Numeric(19,4) |
Numeric(20,4) |
Numeric(20,4) |
Numeric(20,4) |
Numeric(20,4) |
DECIMAL(4) |
N/A |
N/A |
BCD(32,0) |
BCD(32,0) |
Numeric(4,0) |
Numeric(4,0) |
Numeric(4,0) |
Numeric(4,0) |
Numeric(4,0) |
DECIMAL(6,0) |
N/A |
N/A |
BCD(32,0) |
BCD(32,0) |
Numeric(6,0) |
Numeric(6,0) |
Numeric(6,0) |
Numeric(6,0) |
Numeric(6,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) |
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(20,18) |
NUMERIC |
Number |
Number |
Number |
Number |
Numeric(19,4) |
Numeric(20,4) |
Numeric(20,4) |
Double |
Numeric(20,4) |
NUMERIC(4) |
Number |
Number |
Number |
Number |
Numeric(4,0) |
Numeric(4,0) |
Numeric(4,0) |
Double |
Numeric(4,0) |
NUMERIC(6,0) |
Number |
Number |
Number |
Number |
Numeric(6,0) |
Numeric(6,0) |
Numeric(6,0) |
Double |
Numeric(6,0) |
NUMERIC(7,2) |
Number |
Number |
Number |
Number |
Numeric(7,2) |
Numeric(7,2) |
Numeric(7,2) |
Double |
Numeric(7,2) |
NUMERIC(20,18) |
Number |
Number |
Number |
Number |
Err |
Numeric(20,18) |
Numeric(20,18) |
Double |
Numeric(20,18) |
FLOAT |
Number |
Number |
Number |
Number |
Numeric(19,4) |
Numeric(20,4) |
Numeric(20,4) |
Double |
Numeric(20,4) |
FLOAT(4) |
Number |
Number |
Number |
Number |
Numeric(4,0) |
Numeric(4,0) |
Numeric(4,0) |
Double |
Numeric(4,0) |
FLOAT(6,0) |
Err |
Err |
Err |
Err |
Err |
Err |
Err |
Err |
Err |
FLOAT(7,2) |
Number |
Number |
Number |
Number |
Numeric(7,2) |
Numeric(7,2) |
Numeric(7,2) |
Double |
Numeric(7,2) |
FLOAT(20,18) |
Number |
Number |
Number |
Number |
Err |
Numeric(20,18) |
Numeric(20,18) |
Double |
Numeric(20,18) |
CHARACTER(10) |
Alpha(10) |
Alpha(10) |
Alpha(10) |
Alpha(10) |
Character(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) |
Character(10) |
DATE |
Date |
Date |
Date |
Date |
Date |
Date |
Date |
Date |
Date |
BOOLEAN |
N/A |
N/A |
Logical |
Logical |
Logical |
Logical |
Logical |
Logical |
Logical |
BLOB(1,1) |
N/A |
Memo |
Memo |
Memo |
Memo |
Memo |
Memo |
Memo |
Memo |
BLOB(1,2) |
N/A |
Binary |
Binary |
Binary |
Memo |
Memo |
Binary |
Binary |
Memo |
BLOB(1,3) |
N/A |
Formatted Memo |
Formatted Memo |
Formatted Memo |
Memo |
Memo |
Memo |
Memo |
Memo |
BLOB(1,4) |
N/A |
OLE |
OLE |
OLE |
Memo |
Memo |
OLE |
OLE |
OLE |
BLOB(1,5) |
N/A |
Graphic |
Graphic |
Graphic |
Memo |
Memo |
Binary |
Binary |
OLE |
TIME |
N/A |
N/A |
Time |
Time |
Character(8) |
Character(8) |
Character(8) |
Character(8) |
Character(8) |
TIMESTAMP |
N/A |
N/A |
TimeStamp |
TimeStamp |
Character(30) |
Character(30) |
Character(30) |
DateTime |
Character(30) |
MONEY |
Money |
Money |
Money |
Money |
Numeric(19,4) |
Numeric(20,4) |
Numeric(20,4) |
Double |
Numeric(20,4) |
AUTOINC |
N/A |
N/A |
Autoincrement |
Autoincrement |
Numeric(11,0) |
Numeric(11,0) |
Numeric(11,0) |
Autoinc |
Numeric(11,0) |
BYTES |
N/A |
N/A |
Bytes(1) |
Bytes(1) |
Err |
Err |
Err |
Err |
Err |
BYTES(255) |
N/A |
N/A |
Bytes(255) |
Bytes(255) |
Err |
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.
See also Redefining a Table and dBASE: Reverse CREATE modes.