The actual range and storage size of an INT

What’s the difference between INT(2) and INT(20) ? Not a lot. It’s about output formatting, which you’ll never encounter when talking with the server through an API (like you do from most app languages). The confusion stems from the fact that with CHAR(n) and VARCHAR(n), the (n) signifies the length or maximum length of that […]

Know your data – and your numeric types.

Some guidelines to choosing between MySQL’s numeric types, using longitude and latitude as a modelling example.