When creating table, we have to select the data type for each filed. Here is the list of data types in FoxPro 2.6.
|
Data Type
|
Description
|
|
Character
|
- To store string data type i.e., names, words.
- Can hold up to 254 characters
- A-Z, a-z, 0-9, underscore & special symbols
- Default length : 10
|
|
Numeric
|
- To store numerical value with decimal places
- 0-9, .
- Can hold up to 20 digits.
- Decimal part can be 0 to 18 digits
- E.g. usage : Marks, Roll Number
|
|
Float
|
- It has signed numbers
- Can hold up to 20 digits
- E.g. usage : percentage, average
|
|
Date
|
- Used to store date value
- Default format dd/mm/yy
|
|
Logical
|
- Used to store Boolean value : True or False
- Y, N
|
|
Memo
|
- Used to store any amount of Text
- The data stored in in a separate file with .fpt extension.
|
|
General
|
- Used to store text data, picture et.c,
- Used in FoxPro for Windows
|
