Originally Posted by Old Pedant
It's true that, with phpMyAdmin, there would be no way to tell the difference in the display of a NULL field and the display of a (say) varchar(8) field that contains the text string 'NULL', but I'm sure that the creator of phpMyAdmin figured (rightly so) that there's pretty darned close to a zero chance that anybody would actually store 'NULL' in a field's value. (Though they maybe reckoned without considering amateurs who don't know the difference.)
Now that I know what is going on, actually, the way you can tell that a Null is a Null is that phpMyAdmin shows the "placeholder" as an italicized value like this...
I guess it is still sorta annoying to me, since I have a few tables which contain - by design - a fair amount of Null's, and I'd really rather not see NULL
in every instance...
(Is there any way to turn that feature off?)