DB+-+Data+Types

Data Types by Gary :)


 * __There are 8 data types. They are:__

__Text Alphanumeric__** E.g. Smith, EH991AB, £14+VAT.

__**Numeric**__ Either integer (whole numbers) or real (floating points), e.g. 13,3.14.

A special type of numeric field for monetary values, e.g. 12.00,2.50.0.15.
 * __Currency__**

__**Date or Time**__ Dates may be in dd/mm/yyyy format or 'long date' format. Times may be in hh:mm:ss format, or 'long time' format, e.g. 01/01/1990, 1 January 1990 13:30:00, 1:30pm.

Yes or no. Named after George Boole, Mathematician and logician, who created binary logic, e.g. AND, OR, NOT.
 * __Boolean__**

A reference to a file located outside the database.
 * __Link__**

Data such as a picture or sound file.
 * __Object__**

Whether the field must have a value, or can be left blank (called a presence check). Whether the value of the field is limited to certain values (called a restricted choice check,) e.g. Mr/Mrs/Miss/Ms. Numeric fields may be subject to a range check, e.g. the 'year' for a secondary school pupil must be between 1 and 6.
 * __Validation__**