| Author |
Precision problem in Sybase
|
Joe Cheung
Ranch Hand
Joined: Oct 18, 2002
Posts: 104
|
|
|
I tried to insert a double value "0.0491" in Sybase. I found that the value stored in the table is "0.04909999999" that I think is precision loss problem. Does anyone know what the problem is and how I can insert the value exactly "0.0491" rather than "0.04909999999"
|
Joe
|
 |
Shoumin Li
Ranch Hand
Joined: Jul 06, 2007
Posts: 85
|
|
what format of data are you using?
may be you should try to change the format.
|
Java Blog
|
|
Campbell Ritchie
Sheriff
Joined: Oct 13, 2005
Posts: 32638
|
|
It is a standard problem with floating-point arithmetic in any computer.
Does Sybase support a "decimal" data type? That should sort out your problems.
|
|
 |
|
|
subject: Precision problem in Sybase
|
|
|
0
