Data types in Visual Foxpro 6.0 Table

Character
Character data type Can hold 1 to 254 chacracters. Character fields used the fixed-sized defined. If you define a field with 254 characters, the field will use up the space for 254 characters for every record created, even if data entered is less than 254 characters. If you want to store numeric value in a character field, please note that character field will truncate all leading zeros. For example, if you stored 0003 into a chacracter field, Visual Foxpro will truncates the 000 in front and stores it as 3.

Currency
Currency requires 8 bytes of storage space. Currency field can stores values range from -922,337,203,685,477.5807 to 922,337,203,685,477.5807.

Date
Date field requres 8 bytes of storage space. Date field can stores values range from 01/01/100 to 12/31/9999. Date is stored in the form of YYYYMMDD

DateTime
DateTime field requres 8 bytes of storage space. Date field can stores values range from 01/01/100 to 12/31/9999. Date is stored in the form of YYYYMMDD and time is stored as HHMMSS.

Double
Double field requires 8 bytes of storage space and store up to 18 digits.

Float and Numeric
Float and Numeric fields can store up to 20 digits with each digit consume 1 byte of space. Float and Numeric can store up to a maximum of 19 decimal places. In Visual Foxpro, both Float and Numeric are identical.

Memo
Memo field is used to store large character strings which are greater than 254 characters. Data in Memo field will be stored in a seperate file with .FPT extenstion. When you copy the .DBF file from one computer to another, remember to copy the .FPT file as well.

General
Genetal field is a special memo field that can be used to store graphics and OLE Objects.
LogicalLogical field stores boolean true or false.