Best way to store/organise empty data in database?

Databases
4

If you need to display something for empty values, you can.
For example in PHP you may have:-

if(!$this->companyName){ $this->companyName = 'N\A' ;}

Or if your semantics demand the content is blank, you can use CSS to add pseudo content. Eg.

td:empty::after {
    content: 'N\A' ;
}

What you display for blank data (if anything) is entirely up to you.

1 Like