Databases
StackOverflow2013
Postsdbo
POSQlite database not storing double value as string
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQlite database not storing double value as string
    primarykey
    data
    text
    <p>I am using following code</p> <pre><code> public boolean addArea(AreaClass area , ArrayList&lt;AreaMarkClass&gt; areaArray) { area.id = getNextAreaId(); Log.d("longitude", area.longitude); Log.d("latitude", area.latitude); ContentValues initialValues = new ContentValues(); initialValues.put("_id", area.id); initialValues.put("name", area.name); initialValues.put("longitude", area.longitude); initialValues.put("latitude", area.latitude); initialValues.put("zoomLevel", area.zoomLevel); initialValues.put("creationDate",area.creationDate); try { mDb.insertOrThrow("TTArea", null, initialValues); } </code></pre> <p><code>area.longitude</code> is a string whose value is obtained by <code>String.value</code> (A Double Value) Now usually it is something like this <code>22.323434523464563456</code></p> <p>however when i try to retrieve this value </p> <pre><code>public AreaClass getAreaClassWithAreaId(Integer id) { String queryString = "SELECT * FROM TTArea WHERE _id = ?"; Cursor resultSet = mDb.rawQuery(queryString, new String[]{id.toString()}); AreaClass area = new AreaClass(); while(resultSet.moveToNext()) { area = new AreaClass( resultSet.getInt(resultSet.getColumnIndex("_id")), resultSet.getString(resultSet.getColumnIndex("name")), resultSet.getString(resultSet.getColumnIndex("longitude")), resultSet.getString(resultSet.getColumnIndex("latitude")), resultSet.getString(resultSet.getColumnIndex("zoomLevel")), resultSet.getString(resultSet.getColumnIndex("creationDate")) ); } resultSet.close(); return area; } </code></pre> <p>it somehow rounds it to <code>22.3234</code>. In my app i need precise what i am storing. What is this behavior and how can i resolve this?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USlaxonline
    1. USMuhammad Umar
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQlite database not storing double value as string
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POSQlite database not storing double value as string
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COWhat is your table schema? (While SQLite uses "type affinity" in some cases the data type matters.)
      singulars
      1. POSQlite database not storing double value as string
      1. USSam
    2. COHow can i get schema? and how to fix this?
      singulars
      1. POSQlite database not storing double value as string
      1. USMuhammad Umar
    3. COThe "schema" is simply your `CREATE TABLE` statement(s), please post these.
      singulars
      1. POSQlite database not storing double value as string
      1. USSam
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload