In my mysql database we have few nullable integer and date columns.

Earlier we used to enter blank string (”) in these columns when no data was there and it used to insert properly. But not sure after recent server change the same query is not wokring. Getting

incorrect date value: ” for column – error .

How could we fix it? or do I need to explicitly send NULL value? In that case I need to do quite a lot of code change in various places. Kindly suggest.

tried inserting ” in nullable integer/date column of mysql.