Data Types are simply enough the types of data a variable or field in a database can store.

Numerical Data types Edit

Numerical data types are used to represent numeric values. These values can be added, subtracted, multiplied, and divided. Also can have other mathematical functions such as Sine performed on them.

Whole Numbers Edit

Main article: Integer

These numbers are the numbers that do not contain decimal points. Aside from the lack of decimal points, the only restrictions are memory size and whether the number can be negative or not.

Decimal Edit

Main article: Decimal

These numbers contain decimal points. For doing exponentiation, it is highly recommended to use some type of decimal as negative exponents and fractional exponents usually result in some kind of decimal.

Character Edit

Character data types are any data type that isn't numeric, while these types can be used to store numbers, you can't perform mathematical operations on them in this form. You'd have to convert them to a numeric data type first. Usually in this form the addition operator becomes a concatation operator, meaning that if you have a character variable with the number 1 as its current value and try to add a two to it, the programmer will end up with a 12 instead of a 3. It is possible to write programs to add characters as if they are numbers, but not very efficient.

Binary Edit

Usually files or graphics.

User-defined type Edit

Data Type
Programming Character - Floating point Number - User-defined Type - Integer
Database Character - Decimal - Integer - Blob
Community content is available under CC-BY-SA unless otherwise noted.