how can i store a lareg text in mysql table

[alsmurad]

i am facing teh problem of syntax error, when i am writhing this in myqsl 3.32, textNote text(2000) not null, any one can tell me wheather in mysql 3.32 support this kind of data type. i want to store a large text in a table. i am thankf ful inadvance.

 

[sleipnir214]

MySQL doesn't specify a length with the tinytext, text, mediumtext, or longtext column types. It does with the char and varchar types.

Please read here for more information:

http://www.mysql.com/doc/en/Column_types.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!