Paradox types

Generic types

CDS XML MyBase fieldtypes

dBASE 5 types

dBASE 7 types

Autoincrement

Autoinc

Autoinc *

N/A

Autoinc

Alpha

String

string WIDTH = "n"

Character

Character

Short

SmallInt

i2

Numeric(s)

Numeric(s)

Long

Integer

i4

Numeric(s)

Long

Number

Float

r8

Numeric(s,p)

Double

BCD(s)

BCD(s)

fixed  WIDTH = "s"

Numeric(s)

Numeric(s)

BCD(s,p)

BCD(s,p)

fixed DECIMALS = "p" WIDTH = "s"

Numeric(s,p)

Numeric(s,p)

Money

Currency

r8 SUBTYPE = "Money"

Numeric(20,4)

Double

Date

Date

date

Date

Date

Time

Time

time

Character(8)

Character(8)

TimeStamp

DateTime

dateTime

Character(30)

DateTime

Logical

Boolean

boolean

Logical

Logical

Memo

Memo

"bin.hex" SUBTYPE = "Text"

Memo

Memo

Binary

Blob

"bin.hex" SUBTYPE = "Binary"

TypedBinary (for dBASE)

"bin.hex" SUBTYPE = "TypedBinary"

Binary

Binary

FormattedMemo

FmtMemo

"bin.hex" SUBTYPE = "Formatted"

N/A

N/A

Ole

ParadoxOle

"bin.hex" SUBTYPE = "Ole"

DBaseOle (for dBASE)

"bin.hex" SUBTYPE = "dBASEOle"

Ole

Ole

Graphic

Graphic

"bin.hex" SUBTYPE = "Graphics"

TypedBinary (for dBASE)

"bin.hex" SUBTYPE = "TypedBinary"

Binary

Binary

Bytes

Bytes

"bin.hex" WIDTH = "16"

N/A

N/A