And what about not mentioned option "empty value". For numerics it is clear, but for strings, it's dangerous to mix with empty string.

NULL is unassigned value - no value at all, UKNOWN is special logical value, and zero/'' are normal values.