title: Decimal datatype is rounding the values
body: <p>I have set my <code>MySQL</code> field table data type to the <code>decimal</code> because from what I have read, I would be able to store the price with commas/dots in the <code>decimal</code> data type fields... The problem is that whenever I store any data with the comma or dot, MySQL is rounding it automatically up or down. Eg. When I'm executing the following query: </p>
  
  <p><code>UPDATE table SET field = 114.21 WHERE id = 1;</code></p>
  
  <p>Then field is set, but the value is rounded to 114, instead of displaying the data I set in the query (<code>114.21</code>) - is there any solution for that? Or I should just use other data type?</p>