- CHAR (n), TEXT (n), VARCHAR (n).
Alphanumeric data either fixed at n symbols or up to n symbols. It’s not possible to do arithmetic on this data.
- REAL, FLOAT, NUMBER, NUMERIC and DECIMAL.
These are numbers with decimal places.
- INTEGER, LONG, INT, SMALLINT.
These are all whole numbers. They vary in the how big a number they can hold.
- MONEY, CURRENCY.
These are numeric types with decimal places for holding monetary values.
- BINARY, LONGBINARY, GENERAL, IMAGE, OLEOBJECT.
These can hold complete files, such as pictures or media. They are not of a fixed in size, and the upper limit on their size is large.
- DATE, TIME, DATETIME.
These can hold date and time values. These are hybrid types. Although you think of them as text type fields, it is possible to do arithmetic and numeric comparisons on them.