title: Saving float number in SQLite issue?
body: <p>I tried saving some floats into SQLite tables (for the first time) but the stored values are different from what I wanted to save. They were nearly exactly the numbers I saved. This requires me to round or truncate numbers when selecting using query or after filling into DataTable, which may cause the rounded result have a little difference from the actual saved version of the number.</p>
  
  <p>For example, I tried saving this float number 7.64, but the actual saved value was 7.6399998664855957, the same for 6.1 (6.0999999046325684), 4.74 (4.7399997711181641), 5.76 (5.7600002288818359)... </p>
  
  <p>Could you give me some solution for this? Rounding is not what I want, I just want to save exactly what user entering.</p>
  
  <p>Thank you very much in advance!</p>
  
  <h1>UPDATE</h1>
  
  <p>After some testing, I would like to add a note that the problem seems to happen only when I add new values to the table, after added, if I change the values (of course via my application), they are saved exactly what I entered. Here is the code for adding new item:</p>
  
  <pre><code>DataRow dr = myDataTable.NewRow();
  dr["myFloatColumn"] = float.Parse(myTextBox.Text.Trim());
  myDataTable.Rows.Add(dr);
  myDataAdapter.Update(myDataTable);
  myDataTable.AcceptChanges();
  </code></pre>
  
  <p>Thank you!</p>