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.