What is the maximum character length for int and big int?

  • one
    Int and bigint have no characters. Their presentation is in decimal form - 9 and 19, respectively, in unsigned 9 and 20. - etki
  • google: "Mysql data types" - Mike
  • 32 significant number I can not shove in a big int? - Mikhail Lobanov
  • one
    You also said bigint 20 decimal digits. 32> 20. More or less does not fit well. And once again pay attention to my comment about google: "Mysql data types" if you were not lazy and typed it in Google, then after 3 minutes you would already know that you need the numeric data type indicating the desired size - Mike

1 answer 1

TINYINT A very small integer. The range with the sign is from -128 to 127. The unsigned range is from 0 to 255.

SMALLINT Small integer. The signed range is -32768 to 32767. The unsigned range is from 0 to 65535.

MEDIUMINT A medium-sized integer. The signed range is -8388608 to 8388607. The unsigned range is from 0 to 16777215.

INT Integer of normal size. The signed range is from -2147483648 to 2147483647. The unsigned range is from 0 to 4294967295.

BIGINT A large integer. The signed range is from -9223372036854775808 to 9223372036854775807. The unsigned range is from 0 to 18446744073709551615.