Float can't update

Comersus Version: 603
Database type: Other
Frequency: Permanent issue

I want to update my prices, and there are thousands! So I tried:-

UPDATE products SET price=17.99
WHERE price=17.9

But it didn't work.
I found online that float numbers are not stored exactly as they seem.

Would it affect anything if the price was changed from float to decimal?
I can't experiment, as I am getting orders in all the time.

One Comment

Add a Comment

Your email address will not be published. Required fields are marked *