null value and decimal type
newnetJun 1 2008 — edited Dec 22 2014hi, in my form , I have 4 people 's income
People one <input type="text" name="s1Salary" size="15" />
but it possible be null,
and in my back bone I use decimal(6,2), so when I give value in the input file , it work, but if the input file is null, I get error
JDBC error:Incorrect decimal value: '' for column '4th_sibling_Salary' at row 1
java.sql.SQLException: Incorrect decimal value: '' for column '4th_sibling_Salar
y' at row 1
How can I modify it, do I have to use varchar in my Mysql db?