I've been researching and reading through about SQL data types for any couple of days now (I understand... I understand, that's not so lengthy) and one thing that's hard that i can grasp is how you can pick the right data type for expandability, efficiency, and convenience.

I believe it's pretty easy how to pick fundamental Data Types (i.e. int versus varchar) but how can you choose from such things as blob and text type.

The MySQL guy pages are wonderful but they're not what we should computer nerds love... efficient.

It could be awesome when we could compile a listing from the MySQL data types, the overall advantages/disadvantages of every so when it might seem sensible to select that data type.