Data truncated warning?

what does tthis warning mean?

This means that the value you try to put in this columns does not fit

1 Like

but isnt the data nothing (‘’)

Your voltage column(s) are probably defined as DECIMAL. An empty string is not a number and the supplied ‘’ value was truncated to change it be the nearest correct DECIMAL value that fits into the column definition, e.g. a 0. Use a correct value that matches the column definition or allow the column to be NULL and either supply a NULL value or leave the column out of the query, or setup a default value for the column and use the DEFAULT keyword in place of the value.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.