bigint versis int

lottos · Jun 25, 2003

I'm about to add a new field to a table, the field data will never exceed 99999999 so I understand int is the best option.

Does it really make a difference if I use bigint instead and how?

laserlight · Jun 25, 2003

You should check the relevant manual for the column storage types.

For example, for a mysql database,
http://www.mysql.com/doc/en/Column_types.html
In this case, INT is from -2147483648 to 2147483647m while BIGINT from -9223372036854775808 to 9223372036854775807
Quite obviously, using BIGINT is a waste of space for your requirements.