title: sqlite field value rounded off at the time of storing in a double field
body: <p>I have stored location in my sqlite database.</p>
  
  <pre><code>CREATE TABLE city
      (
          latitude NUMERIC,
          longitude NUMERIC
      )
  </code></pre>
  
  <p>Below are the value :- </p>
  
  <pre><code>latitude = 41.0776605;//value in db - NUMERIC stored as DB - also tried with TEXT
  longitude = -74.170086;//value in db - NUMERIC stored as DB - also tried with TEXT
  </code></pre>
  
  <p><strong>UPDATE - When I execute the below query i inspect the value and get that it is giving me the same value which is stored inside the DB but when I am trying to store it in a double variable it is somehow rounding it value and that is why i am getting incorrect value in a variable. Any solution for this?</strong></p>
  
  <pre><code>final String query = "SELECT * FROM city";    
  cursor = myDataBase.rawQuery(query, null);
          if (null != cursor) {
              while (cursor.moveToNext()) {
                  Log.i(TAG, "Latitude == " + cursor.getDouble(cursor.getColumnIndex("latitude")));
                  Log.i(TAG, "Longitude == " + cursor.getDouble(cursor.getColumnIndex("longitude")));
              }
          }
  </code></pre>
  
  <p>Result :- At the time of storing it to String or double variable the values are changes and it is giving me below value.</p>
  
  <pre><code>Latitude = 40.4127
  Longitude = -74.25252
  </code></pre>
  
  <p>I don't want round off this values. Is there any way to solve this problem.</p>