|
<< Click to Display Table of Contents >> Table column types |
  
|
|
<< Click to Display Table of Contents >> Table column types |
|
The following table lists SQL data types and how each is translated by the BDE to native Paradox and dBASE types.
The native column type names (and storage dimensions) in the table below are based on level 7 Paradox and dBASE tables. Column type names and availability vary across the various versions of Paradox and dBASE. For instance, the Binary column type was not available for dBASE IV (level 4) tables.
SQL Syntax |
BDE Logical |
Paradox |
dBASE |
SMALLINT |
fldINT16 |
Short |
Numeric(6,0) |
INTEGER |
fldINT32 |
Long |
Long |
DECIMAL |
fldBCD |
BCD(32,0) |
Numeric(20,0) |
DECIMAL(7) |
fldBCD |
BCD(32,0) |
Numeric(7,0) |
DECIMAL(7,2) |
fldBCD |
BCD(32,2) |
Numeric(7,2) |
NUMERIC |
fldFLOAT |
Number |
Double |
NUMERIC(7) |
fldFLOAT |
Number |
Double |
NUMERIC(7,2) |
fldFLOAT |
Number |
Double |
FLOAT |
fldFLOAT |
Number |
Double |
FLOAT(7) |
fldFLOAT |
Number |
Double |
FLOAT(7,2) |
fldFLOAT |
Number |
Double |
CHARACTER(10) |
fldZSTRING |
Alpha(10) |
Character(10) |
VARCHAR(10) |
fldZSTRING |
Alpha(10) |
Character(10) |
DATE |
fldDATE |
Date |
Date |
BOOLEAN |
fldBOOL |
Logical |
Logical |
BLOB(1,1) |
fldstMEMO |
Memo |
Memo |
BLOB(1,2) |
fldstBINARY |
Binary |
Binary |
BLOB(1,3) |
fldstFMTMEMO |
Formatted memo |
Memo |
BLOB(1,4) |
fldstOLEOBJ |
OLE |
OLE |
BLOB(1,5) |
fldstGRAPHIC |
Graphic |
Binary |
TIME |
fldTIME |
Time |
Character(11) |
TIMESTAMP |
fldTIMESTAMP |
Timestamp |
Datetime |
MONEY |
fldFLOAT, fldstMONEY |
Money |
Double |
AUTOINC |
fldINT32, fldstAUTOINC |
Autoincrement |
Autoinc |
BYTES |
fldBYTES |
Bytes(1) |
N/A |
BYTES(10) |
fldBYTES |
Bytes(10) |
N/A |
