The data type of the null value implied by the keyword NULL cannot be inferred since the null value is in every data type
Although the null value is neither equal to any other value nor not equal to any other value — it is unknown whether or not it is equal to any given value.
A null is the absence of a value in a column of a row. Nulls indicate missing, unknown, or inapplicable data. A null should not be used to imply any other value, such as zero.
Null is the representation of “missing information and inapplicable information”.
Most programming languages use null as an absence of value. Ie the variable is not pointing to any value or object.
The meaning is implementation dependent and can represent the fact that:
- the data was not processed
- or the data is unknown
There is even a null character.