- HubPages»
- Technology»
- Computers & Software»
- Computer Science & Programming»
- Programming Languages
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.