Forums / Built-in Shipping and Payment Modules / Changing products_weight field from float to decimal

Changing products_weight field from float to decimal

Locked

Results 1 to 1 of 1

This thread is locked. New replies are disabled.

25 Aug 2009, 9:04 PM

kwright

Zen Follower

Join Date:: Nov 2004
Posts:: 355
Plugin Contributions:: 0

Changing products_weight field from float to decimal

Is there a reason why the products_weight record needs to be type float?

I would like to change it to type decimal (4,3). Does anyone know if that would cause any issues with the various shipping modules?

The reason for the change is how MySQL handles (or doesn't handle) comparisons with float values...we run reports against a master file with weights of type decimal.

Thanks :smile: