error creating table with type text 1

[mrdance]

I am trying to create a field in MySQL with type text but I get this error;

1064 - You have an error in your SQL syntax near '(2000)' DEFAULT '0') at line 1.

I am using MySQL front and the SQL is like this;

CREATE TABLE news(content TEXT (2000) DEFAULT '0')

Thanks for any help!

 

[rycamor]

TEXT column types are not the same as VARCHAR. They have a fixed maximum length, just like a BLOB (actually, text is just a case-insensitive BLOB). This means you cannot set the length such as TEXT (2000).

TEXT has a default maximum of 65535 characters, and you cannot change this. Also, TEXT and BLOB column types cannot have a default value. CREATE TABLE news(content TEXT); is all you can do with this one.

See

http://www.mysql.com/doc/C/o/Column_types.html

and

http://www.mysql.com/doc/C/R/CREATE_TABLE.html

 

[mrdance]

thank you very much