Storing float numbers as strings in android database

Posted by sandis on Stack Overflow See other posts from Stack Overflow or by sandis
Published on 2010-04-27T07:25:09Z Indexed on 2010/04/27 7:53 UTC
Read the original article Hit count: 266

Filed under:
|

So I have an app where I put arbitrary strings in a database and later extract them like this:

Cursor DBresult = myDatabase.query(false, Constant.DATABASE_NOTES_TABLE_NAME, 
            new String[] {"myStuff"}, where, null, null, null, null, null);
DBresult.getString(0);

This works fine in all cases except for when the string looks like a float number, for example "221.123123123". After saving it to the database I can extract the database to my computer and look inside it with a DB-viewer, and the saved number is correct. However, when using cursor.getString() the string "221.123" is returned. I cant for the life of me understand how I can prevent this. I guess I could do a cursor.getDouble() on every single string to see if this gives a better result, but that feels sooo ugly and inefficient. Any suggestions?

Cheers,

edit: I just made a small test program. This program prints "result: 123.123", when I would like it to print "result: 123.123123123"

SQLiteDatabase database = openOrCreateDatabase("databas", Context.MODE_PRIVATE, null);
database.execSQL("create table if not exists tabell (nyckel string primary key);");

ContentValues value = new ContentValues();
value.put("nyckel", "123.123123123");
database.insert("tabell", null, value);

Cursor result = database.query("tabell", new String[]{"nyckel"}, null, null, null, null, null);
result.moveToFirst();
Log.d("TAG","result: " + result.getString(0));

© Stack Overflow or respective owner

Related posts about android

Related posts about sqlite