Symbol

Data Type

Description

@

Timestamp

8 bytes - two longs, first for date, second for time.  The date is the number of days since  01/01/4713 BC. Time is hours * 3600000L + minutes * 60000L + Seconds * 1000L

+

Autoincrement

Same as a Long

B

Binary, a string

10 digits representing a .DBT block number. The number is stored as a string, right justified and padded with blanks.

C

Character

All OEM code page characters - padded with blanks to the width of the field.

D

Date

8 bytes - date stored as a string in the format YYYYMMDD.

F

Float

Number stored as a string, right justified, and padded with blanks to the width of the field. 

G

OLE

10 digits (bytes) representing a .DBT block number. The number is stored as a string, right justified and padded with blanks.

I

Long

4 bytes. Leftmost bit used to indicate sign, 0 negative.

L

Logical

1 byte - initialized to 0x20 (space) otherwise T or F.

M

Memo, a string

10 digits (bytes) representing a .DBT block number. The number is stored as a string, right justified and padded with blanks.

N

Numeric

Number stored as a string, right justified, and padded with blanks to the width of the field. 

O

Double

8 bytes - no conversions, stored as a double.