MySQL problem

I'm trying to make a mysql table, but he always give me an error which i don't recognize...(i'm a newbie in the MySQL branche)

This is the code + the error

SQL-query :

CREATE TABLE WITHOF (

NUMBER SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
NAME TEXT,
EMAIL VARCHAR,
COMMENTARY TEXT,
PRIMARY KEY ( NUMBER )
)

MySQL output:

You have an error in your SQL syntax near ' COMMENTARY TEXT, PRIMARY KEY (NUMBER))' at line 1

thanx in advance

Isn't NUMBER a reserved word? Try a different label, like ID and see what happens.

MySQL plays loose with some reserved words (like TIMESTAMP, which can be used as a column label), but is picky about others.

I just tried that solution...but it doesn't work... 🙁

and this is the result:

Error

SQL-query :

CREATE TABLE WITHOF (

ID SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
NAME TEXT,
EMAIL VARCHAR,
COMMENTAR TEXT,
PRIMARY KEY ( ID )
)

MySQL gave:

You have an error in your SQL syntax near ' COMMENTAR TEXT, PRIMARY KEY (ID))' at line 1

CHAR and VARCHAR are variable length data types and you have not specified the maximum length for the string. Try VARCHAR(20) instead.

WHOA trucker -- Nice Catch!!

Specified the VARCHAR length and it worked!!!

thanx Truckstuff