org.openhab.ui.habpanel icon indicating copy to clipboard operation
org.openhab.ui.habpanel copied to clipboard

Knob does not store floating numbers into the database (step is floating)

Open gsieben opened this issue 5 years ago • 1 comments

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!

gsieben avatar May 11 '19 22:05 gsieben

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!!!!!

gsieben avatar May 11 '19 22:05 gsieben