title: MySQL table type for money
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/628637/best-data-type-for-currency">Best Data Type for Currency</a>  </p>
  </blockquote>
  
  
  
  <p>I have a table inside my database where I store product prices; the column type is set to <code>DECIMAL(12, 2)</code>. However, whenever I add the following price: <code>1,199.00</code> and save it, for some reason it converts into 1.00. </p>
  
  <p>Or, if I add a price like <code>12,000.00</code>, it converts it to 12. Should I use using some other type of field or add other values to <code>DECIMAL</code>?</p>