title: Storing floating point numbers in android database
body: <p>I'm trying to store dollar amounts in the sqlite database provided by android but it doesn't seem to work properly.  This error only occurs when I try to remove a transaction that aren't whole dollar amounts. i.e. 409.00 will work but 410.44 won't.</p>
  
  <p>If I store a value such as 410.44 and then query the database for that amount I don't get a match. I've tried to use this field as the REAL datatype and the TEXT datatype but neither works.  In the following example the getTransAmount() method returns a float.  This is the version i ran when I had the db datatype as REAL.  Any help would be appreciated.  Thanks.  </p>
  
  <pre><code>cv.put(transAmount, t.getTransAmount());
  
  db.insert(tableName, null, cv);
  x = db.delete(tableName, transAmount + " = " + t.getTransAmount(), null); 
  </code></pre>