Data type groups

SESAM/SQL supports the following data types:

• Strings:

  • Alphanumeric data types:

    • CHARACTER

    • CHARACTER VARYING

  In the SESAM/SQL suite of manuals the term “alphanumeric” expresses the affiliation to an EBCDIC character set, e.g. alphanumeric data type, alphanumeric value, alphanumeric literal. The short forms CHAR and VARCHAR are used in this manual for the alphanumeric data types.

  • National data types:

    • NATIONAL CHARACTER

    • NATIONAL CHARACTER VARYING

  In the SESAM/SQL suite of manuals the term “national” expresses the affiliation to a Unicode character set, e.g. national data type, national value, national literal. The short forms NCHAR and NVARCHAR are used in this manual for the national data types.

• Numeric data types

  • Integer data types:

    • SMALLINT

    • INTEGER

  • Fixed-point number data types:

    • NUMERIC

    • DECIMAL

  • Floating-point number data types:

    • REAL

    • DOUBLE PRECISION

    • FLOAT

• Time data types:

  • DATE

  • TIME

  • TIMESTAMP