Create table syntax error

[miseleigh]

We're porting over to MySQL from MSSQL, and while trying to create the tables in our new MySQL DB we're getting a syntax error that we can't find.

 

CREATE TABLE `makem`.`Clients` (
  `cl_ID` INTEGER UNSIGNED NOT NULL,
  `cl_username` VARCHAR NOT NULL,
  `cl_password` VARCHAR NOT NULL,
  `cl_challenge` TINYINT NOT NULL DEFAULT 0,
  `cl_answer` VARCHAR DEFAULT NULL,
  `cl_name` VARCHAR DEFAULT NULL,
  `cl_contact` VARCHAR DEFAULT NULL,
  `cl_phone` VARCHAR DEFAULT NULL,
  `cl_email` VARCHAR DEFAULT NULL
)
CHARACTER SET utf8;

 

It says there's a syntax error near 'NOT NULL'.  If anyone can spot it, please let me know so I can fix it and make my table.  Thanks!

[fenway]

I thought you had to specify VARCHAR sizes.

[cooldude832]

I believe you can set a standard "default" varchar length and avoid calling it, but yes that is the error