Save float number sqlite error rounding

Question

I'm saving float data in sqlite trough in my aplicaton. The problem is that when I saving the value 99999.99 the sqlite is rounding it to 100000.00. And the same is happening when i try to save 999999.99, its rounding it to 1000000.00. What is happening? The problem is in the Table "custo".

public static final String fghs_CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " +
   asdfgasfdg + " (" +      
    cust + " double, " +

Which data type is using for that? – Amit Gupta Oct 25 '13 at 12:02 — Amit Gupta, Oct 25 '13 at 12:02
What code are you using to store/retrieve column data? – LS_ᴅᴇᴠ Oct 25 '13 at 12:56 — LS_ᴅᴇᴠ, Oct 25 '13 at 12:56

score 0 · Answer 1 · answered Oct 25 '13 at 12:05

0

it seems your sqlite table's column type is integer. If so then use REAL as the data type.

answered Oct 25 '13 at 12:05

stinepike

54,068
14
92
112

He is using a DOUBLE, which is the same as REAL. – Jeffrey Klardie Oct 25 '13 at 12:07

score 0 · Answer 2 · edited May 23 '17 at 10:31

0

You should change the float variable in java to a double, which has a higher precision. The following answer explains the problem.

As pointed out in this answer, the following is a nice example of float precision:

float f = 22.2;
printf("The number is: %.9f\n", f);<>

The output is:

22.200000763

edited May 23 '17 at 10:31

Community

1
1

answered Oct 25 '13 at 12:09

Jeffrey Klardie

3,020
1
18
23

I changed to double and it steel rounding. – Roland Oct 25 '13 at 12:17
Please show the code you use to create the database table, and the cod e you use to insert into the database. – Jeffrey Klardie Oct 25 '13 at 12:19
the code is here. I tryed wit decimal, with double and its rounding yet. – Roland Oct 25 '13 at 12:41
Can you also show the java code where you insert en retrieve data from the database? – Jeffrey Klardie Oct 25 '13 at 13:09

Save float number sqlite error rounding

2 Answers2