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 [...]
Filed under: Good practice / Bad practice by arjen on Monday, March 29, 2010 | Social tagging: birthdate > data types > database > date-of-birth > int > integer > mariadb > mysql > year
No Comments »
Some guidelines to choosing between MySQL’s numeric types, using longitude and latitude as a modelling example.
Filed under: Good practice / Bad practice by toby on Wednesday, December 23, 2009 | Social tagging: accuracy > decimal > double > float > integer > latitude > longitude > mariadb > modelling > mysql > numeric > precision > sql
No Comments »