SQL data types

A distinction is made between the following data types:

• Alphanumeric data type

• National data type

• Numeric data types

  • Fixed-point data types: DECIMAL, NUMERIC

  • Integral data types: INTEGER, SMALLINT

Data types which are formed from these elementary data types also exist. These are called

• Structured data types

The tables below provide information on the permitted content of a record element, and the value range and length of a record element for the various data types.