This is Not a Number
"This is not a number" Error in PHPMyAdmin
While creating an SQL database in PHPMyAdmin, I repeatedly faced this error and after searching the web for a solution, I got nothing useful. Someone who asked about it in a forum was laughed at and was told to press the save button with more force and eventually it will work. People do not blog about less searched keywords, so I didn't really find a good post on this topic.
Finally I resolved the error by making all the field types either TEXT, ENUM or SET; it continually gave error while the type was VARCHAR. But this obviously wasn't the rite way to do it as some values have to be VARCHAR. So, I asked a friend and he told me to enter length in the third column, I did it and everything went alright.
So, the bottom line is that In case you get this error, fill the "Length/Values" field.
Click to enlarge the images.
More by this Author
Here I am sharing a collection of pain quotes with you all.
Here are some nice quotes about women. A collection of quotes about women for all of you to read. A woman's strength is the irresistible might of weakness. Ralph Waldo Emerson A woman can say more in a sigh than a...
I have collected these random facts from various sources on the internet(like Wikipedia), so they may or may not be true. Now please proceed to reading these interesting random bits. Butterflies cannot fly if their...