All
Fields have a type that corresponds to the type of data it represents.
New Fields are created with the character type by default, but the full list of types includes:
- Boolean - true or false
- Character - a string of any characters
- Integer - whole numbers
- Numeric - numbers with a decimal point
- Currency - numbers with currency-specific options
- Date - stored as an integer value, but displayed in date format set in the server preferences
- Time - a time value, in hours, minutes, seconds and milliseconds
- Datetime - date with time
- Object - holds custom JavaScript objects
You can change a Field's type in its Properties View.