6 ms·
I adore SQL NULL. The problem is that people don't use it correctly & the empty string can be a nightmare. SOrry, not adding much to this, but it's a signific
by trollied 7y ago
I adore SQL NULL.
The problem is that people don't use it correctly & the empty string can be a nightmare.
SOrry, not adding much to this, but it's a significant problem in the real world. People often don't understand NULL.
- Koshkin 7y agoThere are many forms of non-existence. Maybe there should be more than one NULL.
- moosingin3space 7y agoAlgebraic data types!
- mr_toad 7y agoSince null doesn’t equal null and is also not not equal to null in SQL, there are effectively unlimited nulls, all possibly different.
- rogual 7y agoHow do you use it? I'm often in a situation where I'm not sure whether it's best to allow NULL, "", or both. If a string column is nullable, should you always disallow ""? Numbers don't have this problem so much, it's really just strings and other types that can be "empty" without being null. Arrays, I guess, though they're not nearly as common.