Anyone else consider their gender 'null'?
TIL- There are people with the last name of Null and this causes them many problems. (NULL literally means nothing or "no value given/entered" in computer language)
So the label 'nonbinary' is one I felt has fit for a while, though it has no meaningful impact on my day to day life. Anyone who knows me IRL has no reason to think of me as anything other than a somewhat GNC cis man, and when it comes to pronouns it's literally 'call me whatever the heck you want' if anyone asked me.
I never thought it of it much beyond that but over time I've realised what 'gender' fits me.
Nullgender.
Not agender. Not linked to male or female in any way. Just not there, like a NULL 'value' in a data set (I work with data sets all the time in my day job).
Not exactly a life-changing revelation, but nice to put a stronger label on it.
Anyone else feel similar?
I have seen database interfaces (e.g. framework libraries) that return 'null' as a string for null columns. I believe there was a flag that would turn this on or off for debugging. This flag allows developers to easily determine if the empty field was a result of a null value or an empty value. This is a bad setting, especially in production, and would explain the issues explained in the article.
The reverse processing of converting 'null' to a null value should generate an application error for a name field. I would expect this to be rather quickly resolved.
There's a good chance that a good chunk of your confusion stems from the journalist's. The article talks about problems using entire application systems, not just databases. Completely reasonable since this is a piece of writing aimed at mass consumption, but technical details are glossed over or misunderstood by the author.
Likely a number of these issues are caused at the application layer, rather than the DB's API. Magic values are an anti-pattern which is ridiculously hard to stamp out of the industry. Very easily some programmer could have written a condition along the lines of "someone typed 'null'? They must mean there's no value, because that's what null means!" A misguided attempt at preventing SQL injection could also be responsible for the mentioned mistreatment of Null, or the Hawaiian last name which contains a single quote, which is also the standard SQL string delimiter.
An application which incorrectly transforms these values into NULL or an empty string can easily create errors if business logic or DB constraints expect something different. This naturally results in exactly the frustrating user experience described in the article.