best mysql field type for temperatures I'm realising that this is the first time I've stored temperatures in a MySQL DB.

What do think the best mysql field type for temperatures (c) is?

Decimial (3,3) ?
You should use DECIMAL (3,1) for temperature in (Celsius)