How are negative temperature values ​​stored in the database?

Question

Database design

Temperature -35
Temperature +30
How is such numerical data stored in the database? The number is a separate field of type number, and the operator is in another field of type text? Or is it done differently?

Answer 1

To store such data, the INT field type is suitable.
In your case, when using MySQL, for example, you can use TINYINT:

• TINYINT[(M)] [UNSIGNED] [ZEROFILL]
  A very small integer. Signed range -128 to 127. Unsigned range 0 to 255.
  

Answer 2

Store in Kelvin, there will be no negative values ​​:-)