Dear Mad,
Don't give a szie just this;
ALTER TABLE tablename ADD fieldname LONGTEXT
Hope this helps,
Richard
MadProfessor wrote:
> Stupid newbie question, but why in the hell can't I get this damned TEXT
> column added? I've specified it as size 254 and cannot get it to
> work Someone plea
I don't believe you specify a size for a column of type TEXT. Only types
CHAR and VARCHAR take a size.
http://www.mysql.com/doc/B/L/BLOB.html says:
"A BLOB is a binary large object that can hold a variable amount of data.
The four BLOB types TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB differ only in
