title: Changing currency decimal positions in mysql
body: <p>I am storing some currency values in my mysql database, I currently have the field type set to decimal(10,2) which gives me prices of £2.22 . I need to change it so it is formatted like this £1.3044  . Every time I input a value of 1.3044 to saves the value 1.30 to the database, does anyone know the correct type to display something like this ? £1.3044</p>
  
  <p>EDIT >>>></p>
  
  <p>After following the answer below, this now works and saves the data in the correct format, the problem is now, for some reason when it re loads it into the form field it changes it to 1.30 even though in the database it is 1.3044.</p>
  
  <pre><code>    &lt;div class="oilprices" style="width:800px; height:auto; float:left;margin-left:15px;"&gt;
        &lt;div style="float:left; width:235px "&gt;&lt;span class="ccms_form_element cfdiv_text" id="oilpricegasoil"&gt;&lt;strong&gt;&lt;span style="font-weight:bold;margin-top:4px; float:left;"&gt;&lt;span style="font-size:15px; padding-right:10px;"&gt;Oil Prices -   &lt;/span&gt; Gas Oil&lt;/span&gt; £&lt;/strong&gt;
            &lt;input name="oilpricegasoil" style="padding:3px !important; background:#fff;" type="text" class="form-field" id="oilpricegasoil" title="oilpricegasoil" size="3" maxlength="10" label_over="0" hide_label="0" /&gt;&lt;span style="padding-left:2px;"&gt;PPL&lt;/span&gt;
      &lt;/span&gt;&lt;/div&gt;
        &lt;div style="float:left; width:130px; margin-left:5px; "&gt;&lt;span class="ccms_form_element cfdiv_text" id="oilpricegasoil"&gt;&lt;strong&gt;Derv £&lt;/strong&gt;
            &lt;input name="oilpricederv" type="text" style="background:#fff;padding:3px !important;" class="form-field" id="oilpricederv" title="oilpricederv" size="3" maxlength="10" label_over="0" hide_label="0" /&gt;&lt;span style="padding-left:2px;"&gt;PPL&lt;/span&gt;
      &lt;/span&gt;&lt;/div&gt;
        &lt;div style="float:left; width:135px; margin-left:5px; "&gt;&lt;span class="ccms_form_element cfdiv_text" id="oilpricegasoil"&gt;&lt;strong&gt;Kero £&lt;/strong&gt;
            &lt;input name="oilpricekero" style="background:#fff;padding:3px !important;" type="text" class="form-field" id="oilpricekero" title="oilpricekero" size="3" maxlength="10" label_over="0" hide_label="0" /&gt;&lt;span style="padding-left:2px;"&gt;PPL&lt;/span&gt;
      &lt;/span&gt;&lt;/div&gt;
      &lt;input name="cf_id" type="hidden" id="cf_id" value=""&gt;
      &lt;div style="width:40px; float:left;padding-left:10px"&gt; 
  
          &lt;input type="submit" name="button" id="button" value="Update"&gt;
  
      &lt;/div&gt;
  
  
      &lt;/div&gt;
  </code></pre>