SQL Field Type

xBase

CHAR(n) where n is the field width

C, n, 0

INTEGER

N, 11, 0

SMALLINT

N, 6, 0

BOOLEAN

L, 1, 0

DATE

D, 8, 0

MONEY

N, 19, 2

FLOAT

N, 19, 4

INTEGER where n is number of digits

N, n, 0

FLOAT(n, p) where n is number of digits and p is precision

N, n, p

NUMERIC(n, p) where n is number of digits and p is precision

N, n, p

BLOB(n) where n is one of the following:

1. Memo

  2. Formatted Memo

  3. Binary

  4. OLE

  5. Graphic/Binary

The extra BLOB types are all handled as Memo (M).

M, 10, 0