org.openhab.ui.habpanel
org.openhab.ui.habpanel copied to clipboard
Knob does not store floating numbers into the database (step is floating)
I created a knop (min=20,max=30,step=0.1).
And I use a mysql server to store the date (persist).
But the software creates an values table with “tinyint(4)” instead of “float”.
The Problem is, that persitance does not work for floating values!
Workarround (alter Table in your sql Database):
ALTER TABLE <name of your schema>
. <name of the tabel>
CHANGE COLUMN Value
Value
FLOAT NULL DEFAULT NULL ;
But restoring the old value does not work. The value 27.7 is set to 27!!!!!