When we add a database field in django we generally write
models.CharField(max_length=100, null=True, blank=True). The same is done with
DecimalField etc. What is the basic difference in having
in respect to different (
DateTimeField) fields. What are the advantages/disadvantages of using 1/2/3?
NOT NULL) on the column in your DB. Blank values for Django field types such as
ForeignKey will be stored as
NULL in the DB.
blank=True determines whether the field will be required in forms. This includes the admin and your own custom forms. If
blank=True then the field will not be required, whereas if it's
False the field cannot be blank.
The combo of the two is so frequent because typically if you're going to allow a field to be blank in your form, you're going to also need your database to allow
NULL values for that field. The exception is
TextFields, which in Django are never saved as
NULL. Blank values are stored in the DB as an empty string (
A few examples:
models.DateTimeField(blank=True) # raises IntegrityError if blank models.DateTimeField(null=True) # NULL allowed, but must be filled out in a form
Obviously those two options don't make logical sense to use (though, there might be a use case for
null=True, blank=False if you want a field to always be required in forms, but optional when dealing with an object through something like the shell.)
models.CharField(blank=True) # No problem, blank is stored as '' models.CharField(null=True) # NULL allowed, but will never be set as NULL
TEXT types are never saved as
NULL by Django, so
null=True is unnecessary. However, you can manually set one of these fields to
None to force set it as
NULL. If you have a scenario where that might be necessary, you should still include
This is how the ORM maps
null fields for Django 1.8
class Test(models.Model): charNull = models.CharField(max_length=10, null=True) charBlank = models.CharField(max_length=10, blank=True) charNullBlank = models.CharField(max_length=10, null=True, blank=True) intNull = models.IntegerField(null=True) intBlank = models.IntegerField(blank=True) intNullBlank = models.IntegerField(null=True, blank=True) dateNull = models.DateTimeField(null=True) dateBlank = models.DateTimeField(blank=True) dateNullBlank = models.DateTimeField(null=True, blank=True)
The database fields created for PostgreSQL 9.4 are :
CREATE TABLE Test ( id serial NOT NULL, "charNull" character varying(10), "charBlank" character varying(10) NOT NULL, "charNullBlank" character varying(10), "intNull" integer, "intBlank" integer NOT NULL, "intNullBlank" integer, "dateNull" timestamp with time zone, "dateBlank" timestamp with time zone NOT NULL, "dateNullBlank" timestamp with time zone, CONSTRAINT Test_pkey PRIMARY KEY (id) )
The database fields created for MySQL 5.6 are :
CREATE TABLE Test ( `id` INT(11) NOT NULL AUTO_INCREMENT, `charNull` VARCHAR(10) NULL DEFAULT NULL, `charBlank` VARCHAR(10) NOT NULL, `charNullBlank` VARCHAR(10) NULL DEFAULT NULL, `intNull` INT(11) NULL DEFAULT NULL, `intBlank` INT(11) NOT NULL, `intNullBlank` INT(11) NULL DEFAULT NULL, `dateNull` DATETIME NULL DEFAULT NULL, `dateBlank` DATETIME NOT NULL, `dateNullBlank` DATETIME NULL DEFAULT NULL )
As said in Django Model Field reference: Link
The following arguments are available to all field types. All are optional.
True, Django will store empty values as
NULL in the database. Default is
null on string-based fields such as
TextField because empty string values will always be stored as empty strings, not as
NULL. If a string-based field has
null=True, that means it has two possible values for "no data":
NULL, and the empty string. In most cases, it’s redundant to have two possible values for "no data"; the Django convention is to use the empty string, not
For both string-based and non-string-based fields, you will also need to set
blank=True if you wish to permit empty values in forms, as the
null parameter only affects database storage (see
When using the Oracle database backend, the value NULL will be stored to denote the empty string regardless of this attribute
True, the field is allowed to be blank. Default is
Note that this is different than
null is purely database-related, whereas
blank is validation-related. If a field has
blank=True, form validation will allow entry of an empty value. If a field has
blank=False, the field will be required.
null=True defines database should accept
NULL values, on other hand
blank=True defines on form validation this field should accept blank values or not(If
blank=True it accept form without a value in that field and
blank=False[default value] on form validation it will show This field is required error.
null=True/False related to database
blank=True/False related to form validation
Here is an example of the field with
blank= True and
description = models.TextField(blank=True, null= True)
In this case:
blank = True: tells our form that it is ok to leave the description field blank
null = True: tells our database that it is ok to record a null value in our db field and not give an error.
When we save anything in Django admin two steps validation happens, on Django level and on Database level. We can't save text in a number field.
Database has data type NULL, it's nothing. When Django creates columns in the database it specifies that they can't be empty. And if you will try to save NULL you will get the database error.
Also on Django-Admin level, all fields are required by default, you can't save blank field, Django will throw you an error.
So, if you want to save blank field you need to allow it on Django and Database level. blank=True - will allow empty field in admin panel null=True - will allow saving NULL to the database column.
When looking at the options in a Django model definition, it's crucial to understand that they serve (at least) two purposes: defining the database tables, and defining the default format and validation of model forms. (I say "default" because the values can always be overridden by providing a custom form.) Some options affect the database, some options affect forms, and some affect both.
When it comes to
blank, other answers have already made clear that the former affects the database table definition and the latter affects model validation. I think the distinction can be made even clearer by looking at the use cases for all four possible configurations:
blank=False: This is the default configuration and means that the value is required in all circumstances.
blank=True: This means that the field is optional in all circumstances. (As noted below, though, this is not the recommended way to make string-based fields optional.)
blank=True: This means that the form doesn't require a value, but the database does. There are a number of use cases for this:
The most common use of this configuration is for optional string-based fields. As noted in the documentation, the Django idiom is to use the empty string to indicate a missing value. If
NULL was also allowed you would end up with two different ways to indicate a missing value.
Another common situation is that you want to calculate one field automatically based on the value of another (in your
save() method, say). You don't want the user to provide the value in a form (hence
blank=True), but you do want the database to enforce that a value is always provided (
Another use of this configuration is when you want to indicate that a
ManyToManyField is optional. Because this field is implemented as a separate table rather than a database column,
null is meaningless. The value of
blank will still affect forms, though, controlling whether or not validation will succeed when there are no relations.
blank=False: This means that the form requires a value, but the database doesn't. This may be the most infrequently used configuration, but there are some use cases for it:
It's perfectly reasonable to require your users to always include a value even if it's not actually required by your business logic. After all, forms are only one way of adding and editing data. You may have code that is generating data which doesn't need the same stringent validation that you want to require of a human editor.
Another use case for this that I've seen is when you have a
ForeignKey for which you don't wish to allow cascade deletion. That is, in normal use the relation should always be there (
blank=False), but if the thing it points to happens to be deleted, you don't want this object to be deleted too. In that case you can use
on_delete=models.SET_NULL to implement a simple kind of soft deletion.
I think you may be interested in Save empty, nullable CharField's as null rather than as an empty string. There are many discussions about this, and a very practical problem you may encounter (eg. you want to add a openid url for each user which can be null and should be unique).
null = True
Means there is no constraint of database for the field to be filled, so you can have an object with null value for the filled that has this option.
blank = True
Means there is no constraint of validation in django forms. so when you fill a
modelForm for this model you can leave field with this option unfilled.
Here, is the main difference of
The default value of both
blank is False. Both of these values work at field level i.e., whether we want to keep a field
null=True will set the field’s value to
NULL i.e., no data. It is basically for the databases column value.
date = models.DateTimeField(null=True)
blank=True determines whether the field will be required in forms. This includes the admin and your own custom forms.
title = models.CharField(blank=True) // title can be kept blank.
In the database
("") will be stored.
blank=True This means that the field is optional in all circumstances.
epic = models.ForeignKey(null=True, blank=True) // The exception is CharFields() and TextFields(), which in Django are never saved as NULL. Blank values a
There's one point where
null=True would be necessary even on a
TextField and that is when the database has the
unique flag set for the column.
In other words, if you've a unique Char/TextField in Django, you'll need to use this:
models.CharField(blank=True, null=True, unique=True)
For non-unique CharField or TextField, you'll be better off skipping the
null=True otherwise some fields will get set as NULL while others as "" , and you'll have to check the field value for NULL everytime.