store null as default value againt Null boolean field

Question

How to use NullBooleanField in Django models with SQLlite3, I want to store null as default value for the nullBoolean field, how do I do that?

I have migrated db from BooleanField to NullBooleanField, but it is still storing False as the default value.

Usage in the code is as:

LOCATOR_YES_NO_CHOICES = ((None,''), (True,'Yes'), (False, 'No'))
employed = models.NullBooleanField(choices=LOCATOR_YES_NO_CHOICES,
                                max_length=3,
                                blank=True, null=True, default="",)

Any example would be of great help.

Answer 1

An empty string "" is not None

>>> "" is None
False

If you want the default to be None then write:

employed = models.NullBooleanField(choices=LOCATOR_YES_NO_CHOICES,
                                max_length=3,
                                blank=True, null=True, default=None,)

Answer 2

Note that NullBooleanFIeld was deprecated in Django 3.1. It is recommended to use BooleanField(null=True).

In this case;

employed = Models.BooleanField(null=True, default=None)