Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the origin (languague derived from) of NULL?

A bit off topic but what is the origin behind NULL?

I sent an email to a French speaking customer containing "thank you for bringing in your NULL 'item'".

Apparently in French, NULL (NUL) translates to:

nul, nulle /nyl/

I. adjective

(familiar) [personne] hopeless, useless;

[travail, étude] worthless;

[film, roman] trashy (colloquial);

Oops, I insulted them. Perhaps of French origin?

like image 232
Luke Hutton Avatar asked Oct 31 '25 08:10

Luke Hutton


1 Answers

Etymology

From Middle French nul, from Latin nullus.

Noun

null (plural nulls)

  1. A non-existent or empty value or set of values.
  2. Zero quantity of expressions; nothing.
  3. (computing) the ASCII or Unicode character (␀), represented by a zero value, that indicates no character and is sometimes used as a string terminator.
  4. (computing) the attribute of an entity that has no valid value.

Since no date of birth was entered for the patient, his age is null.

Adjective

null (comparative more null, superlative most null)

  1. Having no legal validity, "null and void"
  2. insignificant
  3. absent or non-existent
  4. (mathematics) of the null set
  5. (mathematics) of or comprising a value of precisely zero
  6. (genetics, of a mutation) causing a complete loss of gene function, amorphic.

Source: Wiktionary.

Apparently Tony Hoare (of quicksort fame) introduced the concept of null values in computing. He later called that his "billion-dollar mistake" referring to the damage bugs involving null pointers have caused over the decades.

like image 169
Fred Foo Avatar answered Nov 02 '25 22:11

Fred Foo



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!