3 ms·
> The same applies with two people known to have no middle name—where you store a zero length string. I think that's the thing. People use NULL to mean empty v
by progval 7y ago
> The same applies with two people known to have no middle name—where you store a zero length string.
I think that's the thing. People use NULL to mean empty value, instead of unknown value.
Not necessarily for strings because there's the empty string, but for numeric fields, including foreign keys
- sjwright 7y agoAdmittedly non-string fields do make me wish for two kinds of NULL so I can differentiate between zero, confirmed-nothing and unknown. But it's never been an issue for me in practice.