id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
10114	spaces are inserted for 'blank' fields	wmstudio	nobody	"I have a model in which several fields are specified as follows:

{{{
    lat_dec = models.FloatField(blank=True, null=True)
    lon_dec = models.FloatField(blank=True, null=True)
    lat_dms = models.CharField(max_length=9, blank=True, null=True)
    lon_dms = models.CharField(max_length=10, blank=True, null=True)
}}}

In case of the CharFields, spaces are inserted into the database (PostgreSQL) when in the admin form the entry-fields are left blank. I found that out because I made some trigger procedures which update lat_dec and lon_dec when lat_dms and lon_dms (see model) are specified and vice versa. Now I made a workaround by adjusting the trigger procedure so it sets the fields to NULL when containing only spaces."		new	Database layer (models, ORM)	1.0					Unreviewed	0	0	0	0	0	0