"This is not a number!" Error when using VARCHAR type in PhpMyAdmin.

[ilya Kraft]

Hello,

I want to create table with 7 fields to contain some stuff for my website. Some of the fields like (username) are set to VARCHAR and for some reason when I click "save" I get error saying "This is not a number!" I changed all fields from VARCHAR to TINY TEXT and error desapared. Could anyone explain when should I use VARCHAR and is it safe to replace it with TINY TEXT? Also if you know a reason causing this error could you explain how to fix it?

Here is a screenshot of an error

http://inelmo.com/database_error_msg.jpg

Thank You )))

[mwasif]

You need to provide the VARCHAR length (the number of characters). The length is always numeric. See what is VARCHAR. Here is the detail about TINY TEXT.