Data type mappings for CREATE TABLE
The following table lists SQL syntax for data types used with CREATE TABLE, and describes how those types are mapped to Paradox (DB) and dBASE (DBF) types by BDE:
|
SQL syntax |
DB |
DBF 7 |
DBF 5 |
|
SMALLINT |
Short |
Long |
Numeric (6,10) |
|
INTEGER |
Long Integer |
Long |
Numeric (20,4) |
|
DECIMAL(x,y) |
BCD |
Numeric (x,y) |
N/A |
|
NUMERIC(x,y) |
Number |
Numeric (x,y) |
Numeric (x,y) |
|
FLOAT(x,y) |
Number |
Double |
Float (x,y) |
|
CHARACTER(n) |
Alpha |
Character (n) |
Character (n) |
|
VARCHAR(n) |
Alpha |
Character (n) |
Character (n) |
|
DATE |
Date |
Date |
Date |
|
BOOLEAN |
Logical |
Logical |
Logical |
|
BLOB(n,1) |
Memo |
Memo |
Memo |
|
BLOB(n,2) |
Binary |
Binary |
Binary |
|
BLOB(n,3) |
Formatted memo |
N/A |
N/A |
|
BLOB(n,4) |
OLE |
OLE |
OLE |
|
BLOB(n,5) |
Graphic |
N/A |
N/A |
|
TIME |
Time |
N/A |
N/A |
|
TIMESTAMP |
Timestamp |
Timestamp |
N/A |
|
MONEY |
Money |
Numeric (20,4) |
Numeric (20,4) |
|
AUTOINC |
Autoincrement |
Autoincrement |
N/A |
|
BYTES(n) |
Bytes |
N/A |
N/A |
x = precision (default: specific to driver)
y = scale (default: 0)
n = length in bytes (default: 0)
1–5 = BLOB subtype (default: 1)