Paradox field types and sizes
See also
The valid Paradox field types and sizes are
Symbol Size Type
A 1 - 255 Alpha
N Number
$ Money
S Short
I Long Integer
# 0 - 32* BCD
D Date
T Time
@ Timestamp
M 1 - 240** Memo
F 0 - 240** Formatted Memo
G 0 - 240*** Graphic
O 0 - 240*** OLE
L Logical
+ Autoincrement
B 0 - 240*** Binary
Y 1 - 255 Bytes
* Number of digits after the decimal point
** Memo and formatted memo fields can be virtually any length. The value you specify in the Create Table dialog box refers to the amount of the memo Database Desktop stores in the table (1 to 240 characters for memos and 0 to 240 characters for formatted memos). The entire memo is stored outside the table. For example, if you assign a size value of 45 to the field, Database Desktop stores the first 45 characters in the table. It stores the whole memo field in another file (with the extension .MB) and retrieves it as you scroll through the records of the table.
*** Optional
Tip: If all your memos are smaller than a given size (for example, 200 characters), you can save space and time by setting the memo field size equal to or larger than this size. Database Desktop stores the entire memo in the table if it is less than the given size.
