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)