Presently, the temperature table's temperature column is set to be float(4,3), which means the temperature's max is 9.999. This is problematic because when a temperature is saved (and exceeds 9.999), it is set to 9.999.
With the change of making the temperature column a float(5,2), the temperature's max would be 999.99, allowing a more-useful range of temperatures.
Presently, the
temperature
table'stemperature
column is set to befloat(4,3)
, which means the temperature's max is9.999
. This is problematic because when a temperature is saved (and exceeds 9.999), it is set to 9.999.With the change of making the
temperature
column afloat(5,2)
, the temperature's max would be999.99
, allowing a more-useful range of temperatures.