datatype question

[blackdog]

i'm trying to make a field in my table to store articles so i need it to store a large string. i'm using phpmyadmin and i tried making a text datatype with 20000 char max and it says i have an error. anyone know whats wrong? here's the sql:

      CREATE  TABLE  `news` ( `day` INT( 2  )  NOT  NULL ,
  `month` INT( 2  )  NOT  NULL ,
  `year` INT( 4  )  NOT  NULL ,
  `article` TEXT( 20000  )  NOT  NULL ,
  `co1` VARCHAR( 50  ) ,
  `co2` VARCHAR( 50  ) ,
  `co3` VARCHAR( 50  ) ,
  `phone1` INT( 7  ) ,
  `phone2` INT( 7  ) 
 ) 
 
  
       MySQL said:  
 
 #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(65535) NOT NULL, `co1` VARCHAR(50), `co2` VARCHAR(50), `co3` V

[r937]

TEXT does not take a number in parentheses

and in the long run you will be much, much happier to remove the first three columns and replace them with a single DATE column

P.S. could you please edit your message and remove the link to the image on mobilealmanac.com, it scared the pants off me when i first saw it, i thought i had more spyware on my machine

[blackdog]

thanks! post edited