INTEGER
alias is an alternative name for the INT
data type. For example, the following two queries are functionally the same:
INTEGER
is used, the data is stored and treated as INT
.LONG
alias is often used to represent larger integer values. For example:
LONG
is stored and treated as BIGINT
.FLOAT
alias corresponds to the REAL
data type. For example:
FLOAT
, it’s stored and treated as REAL
.DOUBLE
alias is used to define DOUBLE PRECISION
floating-point numbers. For example:
DOUBLE
, it’s stored and treated as DOUBLE PRECISION
.