title: Android - Save location in SQLite database
body: <p>I have problem with save latitude and longitude in SQLite database. I can save some location like (123.123999, 123.123999) and it will save in the database.
  But if I want to read it, I get rounded location like (123.124, 123.124).</p>
  
  <p>My table created by this sql segment:  </p>
  
  <pre><code>CREATE TABLE locs(id INTEGER PRIMARY KEY AUTOINCREMENT, lat DOUBLE, lng DOUBLE, num INTEGER)
  </code></pre>
  
  <p>And querys results:</p>
  
  <pre><code>SELECT * FROM locs WHERE lat = 123.124; //RETURN NO ROWS
  SELECT * FROM locs WHERE lat = 123.123999; //RETURN 1 ROW
  </code></pre>
  
  <p>So I can't use the numbers I get to do queries on the data. </p>
  
  <p>I believe that I am not the first that handling with this problem, because it is basic thing. But I didn't found any answers that work on SQLite database. </p>
  
  <p>How can I read and write the correct number in the db?</p>