- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
Look up the story of the developer in CA who chose the vanity plate "NULL" I think null handling may occupy a close second place to date handing. :(
Admin
Growing up, we had a building which had functioned as an outbuilding of a 1-room schoolhouse since the early 1900's. When preparing for a new paint job, we observed a name carved into the building - Henry Null. This code was undoubtedly written by someone searching for relatives to see if anyone could be charged for the ancient vandalism.
Admin
Hey, when a dictionary adds a definition to the word "literally" of "figuratively". But the definition of "figuratively" remains "not literally"...we are not at the point where literally literally means not literally... so lets rank things by priority....
Admin
LOL WHERE ISNULL(last_name, 'NULL') = 'NULL'
Admin
Fun bit: The gallery app of my mothers rather Old Galaxy A-series phone sorts all photos received by WhatsApp to Jan 1st, 1970.
Admin
Ref: Wiktionary (https://en.wiktionary.org/wiki/literally) which says:
The usage notes say:
Admin
NULL
Admin
Have you every heard about a concept called irony? :-)
Admin
Words that mean "literally" have been used as intensifiers (or, if you prefer, to mean "figuratively") literally forever. No-one gets mad, though, if you say "he really has his head in the clouds". Even the word "very" is derived from "veritably". This is an ancient trend and I don't understand why people have decided to get mad at one tiny aspect of it now.
And obviously, "literally" doesn't mean "figuratively". Can you imagine someone saying "she's figuratively beside herself with anger"? It adds nothing to the sentence. The use of "literally" there would only make sense if it doesn't mean "figuratively.
Admin
Honestly, it sticks in my craw the same way as those who get upset about singular "they", which goes back to the very beginnings of modern English. Yes, it does mean it's sometimes unclear what plurarlity you're discussing- this is usually communicated from context clues, in the same way that pretty much any pronoun requires context clues to convey meaning.
Languages are always going to evolve and change. "The street finds its own uses for things," and that definitely includes words. Honestly, one of the things that's great about English, IMO, is that unlike a lot of other western languages, there is no standards body that says "this is what correct English is", at least none that anyone listens to. Spare us the Académie Française.
Admin
"The problem with defending the purity of the English language is that the English language is as pure as a crib-house whore. It not only borrows words from other languages; it has on occasion chased other languages down dark alley-ways, clubbed them unconscious and rifled their pockets for new vocabulary."
-- James Nicoll, in rec.arts.sf-lovers, May 1990
Admin
I once had to work on a system where the IT manager banned the use of NULLs ("we've had problems with them in the past".) There was a payment field (2 decimals) which could be positive (payment), negative (refund) or zero (no payment required.) Then the issue came up, what do we do if they haven't paid at all? I suggested NULL. I think we wound up with -9999 or something. Ah, good times.
Admin
I recall someone who had a last name of Root had trouble with mail filters that would trigger on the unix root account for filtering.
Admin
Stephen Root maybe? It'd be be funny to hear THAT story :)
https://en.wikipedia.org/wiki/Stephen_Root
Admin
I've worked with databases since the '80s, mainly in government. I've seen LOTS of last names float across my screen. It wasn't until I worked for a school developing a special database project around 2015 that I found a family with the last name of Null. Now, I know better than to try an evaluation like the code sample shown, and I've known better for a very long time. It still kinda blew my mind.
Admin
In the past, I was responsible each month for preparing a mailing list that included a contact whose surname was indeed "Null". The ancient software we used to combine various files into the final list treated the string "Null" as a null value, so the contact's mailing label would end up having only his first name on it.
Admin
On genealogy forums I am often replying "leave it blank if you don't know" to people who invent dates and names. For some reason it is popular to use the surname "Unk" if you don't know the name.
Apparently people dislike empty fields.
Admin
I think he was quoting that from Bill Bryson's "Mother Tongue."
Admin
When I was in the military I actually met someone with a last name of Nul. I instantly thought of "bad" data in databases and string terminators in C.
Admin
That's an impressive feat, quoting from a book which hadn't been published yet.
Admin
I once encountered a database application which was core to the entire operation of an educational institution. The day I arrived I was beseiged by complaints about the slowness. After much time and money being spent the contract developers admitted that they had no real idea of how to delete a person record, and all its associated data - sometimes 100s of items.
So they changed the surname of people who were deleted to 'Kill'. And every SQL statement had a 'WHERE <table.surbamefield> <> 'Kill'. Then in another stroke of genius they executed everything on clients not servers, so huge databases were pumped around to dozens of client stations every minute.
It took ten months for me to get management to admit they were wasting money, brains and time and get rid of the application in favour of an off-the-shelf solution.
I found 3 families surnamed 'Kill' in local directories - thank goodness none of them tried to enrol.
Admin
Addendum 2024-03-07 01:53: Bloody layout is not working properly again.
Admin
The Académie Française is the best thing ever we have in French. Literally. It only further highlights how we mistreat the language, and yet doesn't prevent anyone from doing so. C'est l'exception qui confirme la règle.
Admin
I wonder if Mr. Pascal Nil are experiencing any problems?
Admin
"They could just store a NULL, but due to data sanitization issues, they stored 'NULL' instead- a string. "
Apparently their data sanitization issue was that they didn't want to have any.
Admin
So, literally there is no word in the English language we can use to express the concept of something being literally true?
Admin
Do you mean that literally figuratively or literally literally?
Admin
Yes, that's a fair analysis. Exceptional claims require exceptional evidence, so if you're going to say that you were literally glued to your seat, or literally at the head of the class, or literally on top of the world, then you'll need either to tell the story of how you came to be in that situation or to accept that people will understand you as speaking figuratively despite your choice of words.
For less exceptional claims ("I was literally the first customer at the store that day"), people are more likely to take you at your word. Of course, in those cases, the word "literally" doesn't actually add any meaning.
Admin
One form I've seen often, including before the widespread redefinition of how "literally" is used, is "quite literally". I think that phrase is still understood to quite literally mean "literally".