There are a number of different column types that can be assigned to a table, each one defined by its Data Type. This affects everything from the formatting of the data in the table to the way data is entered; information needs to be stored matching that data type. If the data entered into the column doesn't match its type, an error will occur.
The following list will introduce you to the data types you can assign to a column, and describe why you might want to use them when you create a table:
| Data Type | Description |
|---|---|
| Yes or No | Stores True and False values. This is also known as a Boolean data type. |
| Text | Stores values up to a maximum of 4000 characters, and can include letters, numbers, punctuation and white space. |
| Whole | Stores integer values. |
| Decimal | Stores numbers with up to two decimal places. |
| Date | Stores a date and time based on a 24 hour clock. |
| Unique | Stores a GUID (Globally Unique Identifier). |
| Money | Stores currency values up to 4 decimal places. |
| Geography | Stores geolocation values. You can search for an address, and return its latitude and longitude co-ordinates. |
| Document | Used with the File Uploader question type, stores the base64 string of a document or image file. |