title: Choosing data type for MySQL?
body: <p>I have been researching and reading about SQL data types for a few days now (I know... I know, that's not very long) and one of the things that is hard for me to grasp is how to pick the best data type for expandability, efficiency, and ease of access. </p>
  
  <p>I think it's pretty straight forward how to choose basic Data Types (i.e. int vs varchar) but how do you choose between things like blob and text type.</p>
  
  <p>The MySQL man pages are great but they are not what we computer geeks love... efficient.</p>
  
  <p>I think it would be awesome if we could compile a list of the MySQL data types, the general advantages/disadvantages of each and when it would make sense to choose that data type.</p>