News for hackers. Stuff that matters.
Re:My last name makes me invisible to Computers (2015) by Animats on Saturday August 19, 2017 @12:11AM (#15051622)
One place where that can easily happen is loading comma-separated value files into a database. Some CSV files are formatted with the convention that fields only appear in quotes if they contain special characters. Thus, a data value of NULL is not quoted. This loses the distinction made in SQL databases between NULL, the null value, and "NULL", the string.

(I just received some files like this. One is a file that has names. If someone had a name of NULL, it would go into the database as a null.)

There are no comments on this comment yet.