Hazukiy Posted March 6, 2014 Share Posted March 6, 2014 Hi, I'm currently trying to get my database for my website to work but at the moment I'm having a lot of issues with the new version? Basically I'm trying to create a simple registration table setup which includes: - user_id - firstname - lastname - username - email - password And the problem is that when I put them all in, set the Index's and the data types, it comes up with a message saying: "This is not a number"? I have no idea why it keeps coming up with this, any ideas? Here's what it looks like at the moment http://i.imgur.com/faOXjrs.png Thanks. Quote Link to comment Share on other sites More sharing options...
Ch0cu3r Posted March 6, 2014 Share Posted March 6, 2014 (edited) You are getting that error because VARCHAR datatypes requires you to define the maximum number of characters that can be stored for each field. Edited March 6, 2014 by Ch0cu3r Quote Link to comment Share on other sites More sharing options...
Hazukiy Posted March 6, 2014 Author Share Posted March 6, 2014 Ah ok and apart from that, would you say that all the datatypes are correctish? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.