By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,376 Members | 3,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,376 IT Pros & Developers. It's quick & easy.

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

ilya Kraft
100+
P: 134
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 )))
Jun 11 '11 #1

✓ answered by 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.

Share this Question
Share on Google+
1 Reply


mwasif
Expert 100+
P: 801
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.
Jun 12 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.