News for hackers. Stuff that matters.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by calibas on Monday February 03, 2025 @03:24PM (#42922537)
Which systems use the string "null" to represent a null value? That seems like a bad idea...
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by threeducks on Monday February 03, 2025 @03:40PM (#42922777)
A common source of "NULL" strings are CSVs. I personally had to deal with a database that only understood NULLs correctly when using QUOTE_NOTNULL, which was added to Python just last year: https://github.com/python/cpython/issues/113732

I've also heard of a fun database where the user "Geoffrey" was truncated to "G". I wonder why? (Hint: End of file)

Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by driggs on Monday February 03, 2025 @04:01PM (#42923059)
> I've also heard of a fun database where the user "Geoffrey" was truncated to "G". I wonder why? (Hint: End of file)

Sorry, I don't buy that one. There's no way the ascii string "eof" - especially lower-cased - would be interpreted as the C macro EOF, which is typically represented as the int -1. Sounds like a tall tale unless you've got proof.

Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by snailmailstare on Monday February 03, 2025 @04:18PM (#42923298)
I first had to figure out why the G stayed put if it was being treated as last line... I've seen some terrible things and wouldn't doubt that a lot of pages in say the travel industry have a 2%+ failure rate at recording a signup.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by somat on Monday February 03, 2025 @04:11PM (#42923205)
I could see a poorly coded stringly parsed interface (think sql) triggering on a mid span character sequence. but I agree, it would have to be a real mess of an interface. For example the client uses "eof" to separate or end queries.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by NoMoreNicksLeft on Monday February 03, 2025 @04:29PM (#42923468)
There are more than a few legacy databases where a person's first name wouldn't be lowercased. I worked for a university awhile back, this is post-2010, and names were stored uppercase.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by threeducks on Wednesday February 05, 2025 @02:21PM (#42953695)
Sorry, I don't have first-hand proof. But it seems that this issue is not rare: https://old.reddit.com/r/programminghorror/comments/4g70lj/s...
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by Sohcahtoa82 on Monday February 03, 2025 @07:37PM (#42925664)
CSV will go down as one of the greatest mistakes in computer programming.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by jazzyjackson on Monday February 03, 2025 @03:36PM (#42922720)
I could see it happening with clumsy JSON parsing. in javascript, JSON.parse("null") would return null, and the string null would have to be JSON.parse('"null"').
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by robin_reala on Monday February 03, 2025 @03:50PM (#42922904)
ColdFusion, if I remember correctly.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by dartos on Tuesday February 04, 2025 @12:51AM (#42928547)
Never underestimate the amount of bad ideas in code produced by the lowest bidder.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by poobear22 on Monday February 03, 2025 @03:59PM (#42923026)
Sometimes you can call 1-800-dev-null to get this fixed.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by dylan604 on Monday February 03, 2025 @04:27PM (#42923441)
i now know the phone number that i will use whenever some form wants a number and i don't think they really need it. 555-1212 is my go to, but 338-6855 is so less obvious.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by quantified on Monday February 03, 2025 @04:59PM (#42923850)
Who's at the other end of that number. No one who had the number appreciated the pop song's 867-5309 but at least one day with the radio on told them why they were getting all these crank calls.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by dylan604 on Monday February 03, 2025 @08:07PM (#42925985)
> Who's at the other end of that number.

Does it matter?

Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by quantified on Monday February 03, 2025 @08:43PM (#42926387)
Well, they may get some calls or texts, so ethically I'd hope you choose to minimize harm.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by dylan604 on Monday February 03, 2025 @10:08PM (#42927295)
I doubt any of the people collecting phone numbers as an identifier are actually making any calls. They use it as the ID to link all of your data collected by them by anyone else that buys that data to other data they've bought from other suppliers.

In fact, if that is a legit number, then all I'm doing is increasing their rewards points or whatever. Sure, maybe messing with their recommendations like when you share your Spotify account, but that's a whole lot of meh from me on that.

Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by LorenDB on Monday February 03, 2025 @02:47PM (#42922041)
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by Krasnol on Monday February 03, 2025 @03:44PM (#42922828)
We had a patient with a single letter as surname. Didn't go well with our patient web portal. She'll probably never be able to see her MRIs online since development is slow, and it seems to be an edge case.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by throwway120385 on Monday February 03, 2025 @04:08PM (#42923150)
This is a really good example of how limits on name fields are entirely arbitrary.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by caseyohara on Monday February 03, 2025 @04:06PM (#42923134)
Why would the length of the surname matter?
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by tiltowait on Monday February 03, 2025 @04:17PM (#42923280)
At a guess, the system mandates a minimum length.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by dylan604 on Monday February 03, 2025 @04:28PM (#42923458)
O-muhgawdthisisstupid would be my next attempt
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by quantified on Monday February 03, 2025 @05:03PM (#42923887)
Well, challenge question "secret answers" also have similar stupids. Mandating five-letter answers mean that first pet Fido, favorite teacher Zak, honeymoon destination Fiji, etc all cannot be used. Though honest answers to those questions are the worst idea.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by not2b on Monday February 03, 2025 @04:20PM (#42923335)
Is the name "O"? That's a common Korean surname, though many Korean Americans spell it "Oh" to avoid the problems computers and bureaucrats have with it.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by juliendorra on Tuesday February 04, 2025 @01:52PM (#42936848)
We had a minister of digital affairs in France who is named O (Cédric O, early investor in Mistral too)
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by julian_t on Monday February 03, 2025 @04:38PM (#42923567)
I have several Indian coworkers who have a single name. Our company systems insist on first and last names, so they either end up with '.' as a last name, or the same name twice.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by the_real_cher on Monday February 03, 2025 @05:03PM (#42923896)
would just make one up at that point.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by aaplok on Monday February 03, 2025 @05:18PM (#42924075)
This works until someone asks you to produce identity documents matching the computer records.

I've seen people put a single period (".") instead of a last name.

Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by briffle on Monday February 03, 2025 @04:53PM (#42923750)
first real job was at a 2-year rural college.

We had 2 systems, one for students, one for staff. Sometimes people would forget to properly reference the 'other' account when a teacher took a class, or a student taught a community education class, etc. We were in the process of consolidating into a single DB, and didn't want a bunch of duplicates.

We had a person Leslie that kept getting duplicated in the systems. Same address same age, same birthdate. Only difference was different gender, and last 2 digits of social was 21 instead of 12.

So our dba deleted one, and linked them.

Month later, same thing. So our DBA fixed it. Shaking his head at the people up front not following data entry procedures.

Next week, both Leslie's were in our office. They were born on same day, but hospitals in nearby towns. Back then socials were handed out sequentially by region. They had different last names until they married 40 years before.

They were laughing and said this happens more often then most people would think.

Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by OptionOfT on Monday February 03, 2025 @05:15PM (#42924032)
I lived in a 2 letter town. For the longest time I couldn't order stuff off of websites as they required a 3 letter city.

Ah-well, I saved some money because of this.

Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by pnemonic on Monday February 03, 2025 @04:29PM (#42923475)
obligatory mention of Little Bobby Tables
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by djmips on Monday February 03, 2025 @05:18PM (#42924084)
He should have an advice blog called Null's pointers.
Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by kmoser on Monday February 03, 2025 @04:35PM (#42923526)
Related: How a 'NULL' License Plate Landed One Hacker in Ticket Hell https://www.wired.com/story/null-license-plate-landed-one-ha...

And: What Happens When Your License Plate Says 'NO PLATE'? https://www.snopes.com/fact-check/auto-no-plate/ (including a mention of a "VOID" plate)

A bit of a tangent: I know someone whose last name is "Tester" whose medical records were always getting filled with wild diseases and eventually they figured out that the doctors-in-training were practicing entering medical records using her account.

Re:Hello, I'm Mr. Null. My Name Makes Me Invisible to Comput... by zippyman55 on Tuesday February 04, 2025 @02:36AM (#42929303)
My Glassdoor dummy account is something like Mr Null at 001 null drive. I’m amazed the feedback from the null corporation I get. There are a lot of other employees who appear to work there. Work seems pointless. Dead end. A clear lack of direction. Lots of dead ends.