SQL Dialects Reference/Data structure definition/Data types/Numeric types

numeric-types.html datatype3.html Integer (1 byte) SMALLINT, INTEGER, INT, BIGINT, DECIMAL and NUMERIC. See: Wikibook SQL tinyintinteger1 SQL%20Reference%20Guide/numericdatatypes.htm#o2044 tinyint (always unsigned) 187745 TINYINT TINYINT NUMBER(1) "char" (including quotation marks) INTEGERuses dynamic typing; allows any type name TINYINT Integer (2 bytes) SMALLINT r0008469.htm SMALLINT smallintinteger2 SQL%20Reference%20Guide/numericdatatypes.htm#o2044 smallint 187745 SMALLINT SMALLINT NUMBER(2) SMALLINTINT2 datatype-numeric.html#DATATYPE-INT INTEGER SMALLINT SMALLINT Integer (3 bytes) MEDIUMINT NUMBER(3) INTEGER Integer (4 bytes) INTEGER r0008469.htm INTEGER integerinteger4 SQL%20Reference%20Guide/numericdatatypes.htm#o2044 int 187745 INT INT NUMBER(4) INTINTEGERINT4 datatype-numeric.html#DATATYPE-INT INTEGER INTINTEGER INTINTEGER Integer (8 bytes) BIGINT r0008469.htm BIGINT bigintinteger8 SQL%20Reference%20Guide/numericdatatypes.htm#o2044 bigint 187745 BIGINT BIGINT INTEGER BIGINTINT8 datatype-numeric.html#DATATYPE-INT INTEGER BIGINT BIGINT Float (single precision, 4 bytes) FLOAT, REAL, DOUBLE PRECISION. See: Wikibook SQL REAL r0008469.htm FLOAT float4realfloat(23) SQL%20Reference%20Guide/numericdatatypes.htm#o2639 realfloat(24) 173773 FLOAT REAL BINARY_FLOAT REALFLOAT(24) datatype-numeric.html#DATATYPE-FLOAT REAL FLOATREALFLOAT(n), n≤24 Float (double precision, 8 bytes) DOUBLEFLOAT r0008469.htm DOUBLE PRECISION floatfloat8double precisionfloat(53) SQL%20Reference%20Guide/numericdatatypes.htm#o2639 floatfloat(53) 173773 DOUBLE FLOAT DOUBLE BINARY_DOUBLE DOUBLE PRECISIONFLOAT(53) datatype-numeric.html#DATATYPE-FLOAT REAL FLOAT DOUBLEDOUBLE PRECISIONFLOAT(n), n>24 Fixed precision (p) and scale (s) number DECIMAL(p, s)NUMERIC(p, s) r0008469.htm DECIMAL(p, s)NUMERIC(p, s) DECIMAL(p, s)NUMERIC(p, s) decimal(p, s)numeric(p, s) 187746 DECIMAL(p, s)NUMERIC(p, s) DECIMAL(p, s)NUMERIC(p, s) NUMBER(p, s)/NUMBER(p)/NUMBERDECIMAL(p, s)/DECIMAL(p)/DECIMALNUMERIC(p, s)/NUMERIC(p)/NUMERICFLOAT(p) DECIMAL(p, s)NUMERIC(p, s) datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL DECIMAL(p, s)NUMERIC(p, s) DECIMAL(p, s)DEC(p,s)NUMERIC(p, s)NUMBER(p,s) Fixed precision p and s limits no limits p ≤ 31, 0 ≤ s ≤ p r0008469.htm p ≤ 18, 0 ≤ s ≤ p p ≤ 31, 0 ≤ s ≤ p p ≤ 38, 0 ≤ s ≤ p 187746 p ≤ 65, 0 ≤ 30 ≤ s ≤ p p ≤ 18, 0 ≤ s ≤ p p ≤ 38, -84 ≤ s ≤ 127 (for negative scale the least significant digit is on the left side of the decimal point) p ≤ 1000, 0 ≤ s ≤ p datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL p ≤ 30, 0 ≤ s ≤ p, s ≤ 10, p-s ≤ 20 UNSIGNED support Set display width in integer |}