Data type precision (field length) range (decimal places) is as follows:
Short integer *1–4 (Oracle Bone Inscriptions); 1–5(SQL Server、PostgreSQL); 5(DB2、Informix) 0
Long integer 5–5-10 (Oracle Bone Inscriptions); ); 6- 10(PostgreSQL); 6-9(DB2, Informix and SQL Server) 0
Floating-point type1–61–6
Double precision 7+ 0+
Extended data:
The binary bit length of short integers is 16, and that of long integers is 32 bits. That is, a long integer can represent an integer with more digits. The integer range that short integers can represent is -32768~32767.
Long integer is-2147483648 ~ 2147483647. For example, there is a number 32780, which can only be represented by a long integer, not a short integer.
Long integer is a representation of data type in programming, usually represented by long. The range of signed 64-bit integer of Long is -2 63-2 63- 1 int 64; the 64-bit integer of unsigned long is 0-2 64- 1 uint64.