
Appendix A
Data Structure
241
Yes/No Yes and No values and fields that contain only one of
two values. Yes/No fields can't be indexed.
OLE Object An object such as a Microsoft Excel spreadsheet or a
Microsoft Draw graphic that is created by an object
application. The maximum size is about 1 gigabyte.
OLE Object fields can't be indexed.
TABLE 15. Numeric Fields Size Settings
Field Type Size Settings
Byte Stores numbers from 0 to 255 (no fractions). It occu-
pies 1 byte.
Integer Stores numbers from -32,768 to 32,767 (no fractions).
It occupies 2 bytes.
Long Integer Stores numbers from -2,147,483,648 to 2,147,483,647
(no fractions). It occupies 4bytes.
Single Stores numbers with six digits of precision, from -
3.402823E38 to 3.402823E38. It occupies 4 bytes.
Double (Default) Stores numbers with 10 digits of precision,
from -.79769313486232E308 to
1.79769313486232E308. It occupies 8 bytes.
TABLE 14. Data Type Settings (Continued)
Field Type Size Settings
2287.book Page 241 Thursday, July 7, 2011 4:45 PM
Comentarios a estos manuales