J2.5:How do I store empty values as NULL in the database?
From Joomla! Documentation
If you want to store empty values as NULLs into the database, you need to override JTable::store() and JModelAdmin::prepareTable(). Add following snippets of code into your component's admin/tables/nameoftable.php and admin/models/nameofeditview.php
admin/tables/nameoftable.php
public function store($updateNulls = true) {
/* overload JTable::store() to enable updating values into NULL */
return parent::store(true);
}
admin/models/nameofeditview.php
protected function prepareTable($table)
{
/* define which columns can have NULL values */
$defnull = array('array','of','columns','that','can','have','null','value');
foreach ($defnull as $val)
/* define the rules when the value is set NULL */
if (!strlen($table->$val))
$table->$val = NULL;
}