Why isn't my code working?
CREATE TABLE article(
id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT ,
title VARCHAR( 250 ) NOT NULL UNIQUE ,
subtitle VARCHAR( 250 ) ,
article_date DATE NOT NULL ,
author VARCHAR( 100 ) ,
body VARCHAR( 65000 ) NOT NULL ,
end_notes VARCHAR( 10000 ) ,
created_on DATETIME NOT NULL ,
PRIMARY KEY ( id )
MySQL said: Documentation
1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
I would like the body field to be the maximum VARCHAR size of 65,535 to hold really long articles. (I estimate this should hold up to about 40 pages?!) :-/
I tried using VARCHAR and also VARCHAR() but nothing works...