title: MySQL field type for storing decimals
body: <p>I'm creating a DB that will hold products with several "height" columns (in meters, for ex 7.79 or 12,8). Never more than 2 digits before and 2 after the decimal point. What field type should I use for this?</p>
  
  <p>If I use decimal(2,2) an try to insert 7.79 in phpmyadmin I get an error saying Warning: #1264 Out of range value for column 'working_height' at row 1</p>
  
  <p>I'll be using this DB for searching, so I have to be able to run a query like "select all products where height is great than 7".</p>