Numeric Data Types
-
Numeric Data Type Overview
Overview and usage of the numeric data types. -
TINYINT
Tiny integer, -128 to 127 signed. -
BOOLEAN
Synonym for TINYINT(1). -
SMALLINT
Small integer from -32768 to 32767 signed. -
MEDIUMINT
Medium integer from -8388608 to 8388607 signed. -
INT
Integer from -2147483648 to 2147483647 signed. -
INTEGER
Synonym for INT -
BIGINT
Large integer. -
DECIMAL
A packed "exact" fixed-point number. -
DEC, NUMERIC, FIXED
Synonyms for DECIMAL -
NUMBER
Synonym for DECIMAL in Oracle mode. -
FLOAT
Single-precision floating-point number -
DOUBLE
Normal-size (double-precision) floating-point number -
DOUBLE PRECISION
REAL and DOUBLE PRECISION are synonyms for DOUBLE. -
BIT
Bit field type. -
Floating-point Accuracy
Not all floating-point numbers can be stored with exact precision -
INT1
A synonym for TINYINT. -
INT2
Synonym for SMALLINT. -
INT3
Synonym for MEDIUMINT. -
INT4
Synonym for INT. -
INT8
Synonym for BIGINT.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
