Hacker News new | ask | show | jobs
by karmakaze 1525 days ago
Exactly.

> “null” is also a text string that in many programming languages signifies a value that is empty or undefined.

I can't think of a single language that does this. A null interpolated into a string or concatenated with an empty one could produce such a string. If that string value is then used to signify an empty/undefined value is misuse of the language.

1 comments

SQL is more of a data language, but things like T-SQL or P-SQL I guess count. Lots of programming languages interacting with SQL databases mistreat NULL values. This guy's plate should never be "IS NULL" but should be a string that "plate = 'NULL'".
I think it would be more the case that specific programs (or stored procedures) mistreat NULL values, rather than a language or library not providing a way to properly handle them.