integer and int (column types)

1. Accepts character strings (generously cast or not statically typed)
2. Use int64

The SQL type integer (short: int) is typically no shorter than a 32 big signed integer (-2147483647 to 2147483647).

CREATE TABLE table_name (
   column_name_1 INTEGER,
   column_name_2 INT
)

Note that the SQL language has no unsigned modifier (see: domain, check).

Related

• Integer in other places: cast target.

• Other integer types: smallint, bigint

• Restricting the value range (e.g. unsigned): domain, check

• SQL types for decimal numbers: numeric, decimal, decfloat

• Numeric types with approximate arithmetic: float, real, double precision

• Product specific integer types: tinyint, mediumint, int2, int4, int8, int64, unsigned, signed

Normative References

The type integer and its abbreviation int are defined in ISO/IEC 9075-2:2023 (E011-01, “INTEGER and SMALLINT data types (including all spellings)”) with an implementation defined precision.0 The corresponding data type of the C programming language is long,1 which corresponds to the above mentioned value range.2