54 ms·

Maybe they were using an Oracle database, where (shockingly) empty strings are treated as equivalent to NULLs. Edited to add: A "famous" wtf-worthy explainer f

Maybe they were using an Oracle database, where (shockingly) empty strings are treated as equivalent to NULLs. Edited to add: A "famous" wtf-worthy explainer from Oracle: https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:5984520277372 https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUEST... Relevant snippet: '' when assigned to a char(1) becomes ' ' (char types are blank padded strings). '' when assigned to a varchar2(1) becomes '' which is a zero length string and a zero length string is NULL in Oracle (it is no long '')

hunter2_ 5y ago
The conflation of empty string with a real null isn't great, but it doesn't also imply conflation of the string "NULL" which is what I'm trying to figure out. The four-character sequence shouldn't ever be considered something other than a four-character string, except for particular non-user-facing situations such as when actually writing code. Even spreadsheet software, which does all kinds of heuristics to find numbers in strings for example, doesn't treat the string "NULL" as anything other than a four-character string, to my knowledge.