Data Types in FoxPro

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