Strange problem with double in database mysql

Asked Jan 15 '20 at 15:17

Active Jan 15 '20 at 15:21

Viewed 15 times

I have some database table double:

 (somenumber float(11,2) DEFAULT '0.00' NOT NULL,)

If I try to save number "1.91" or "1.93" I get error like:

These fields of record 95 in table "tx_xxx_yyy" have not been saved correctly: somenumber! The values might have changed due to type casting of the database.

If I save muber "1.92" or "1.94" I do not get error.

Is this a MySql bug?

Thanks Martin

edited Jan 15 '20 at 15:21

Strawberry

33,750
13
40
57

asked Jan 15 '20 at 15:17

matin

Everybody here has 'some strange problem' – Strawberry Jan 15 '20 at 15:21
[What every programmer should know about floating point](http://pages.cs.wisc.edu/~david/courses/cs552/S12/handouts/goldberg-floating-point.pdf) – RiggsFolly Jan 15 '20 at 15:26
Or do a google for `what every should know about floating point` and pick one you like the look of – RiggsFolly Jan 15 '20 at 15:28

Strange problem with double in database mysql

0 Answers0