title: Java Mysql Order by Price
body: <p>I am using Google cloud mysql v.5.5 for a Java based development.</p>
  
  <p>I am trying to order by the resulting data set by price, but until now, prices arent being ordered.</p>
  
  <p>Lets say my query is : </p>
  
  <pre><code>SELECT ID, ITEM_NAME, PRICE FROM REFERENCES .... ORDER BY PRICE ASC
  </code></pre>
  
  <p>Table References has 4 elements. The prices for those elements are : 1, 12, 12.2 and 2.</p>
  
  <p>When i run the query what i am getting is : </p>
  
  <pre><code>1
  12
  12.2
  2
  </code></pre>
  
  <p>And i should be getting :</p>
  
  <pre><code>1
  2
  12
  12.2
  </code></pre>
  
  <p>Any idea what might going on?</p>
  
  <p>Thank you in advance for your time,</p>
  
  <p>Kind regards,</p>
  
  <p>UPDATE1: The field type for PRICE column is VARCHAR as a client prereq, so not much to do about this.</p>
  
  <p>UPDATE2: Price value contains a ',' instead of the usual '.' , so even with the responses i've got until now the results keep being less messy but messy anyways. :(</p>
  
  <p>UPDATE3: Also, i have tried to do the following : ORDER BY replace(PRICE, ',', '')+0 ASC but this also has proven to be unsuccessful. :(</p>