Page 1 of 1

Data type

Posted: Sun Apr 13, 2003 4:27 pm
by minds_gifts
Hello everybody,

I've got a search script where it searches for the keywords in a table.Well basically the table structure looks like

Article_id, Article_name, Article_file, Article_keywords

I tested the script with each Article_name having upto 5 keywords.Its absolutely working fine.

My Question is:

1.There are chances that each of the article can have a maximum of 100 key words in future.
Does it make sense if I put the data type of Article_keywords as text.Right now, its varchar.

Thanks everybody

Posted: Sun Apr 13, 2003 4:33 pm
by twigletmac
If you need the field to store more than 255 characters then TEXT is more appropriate as it can store lots more (pages and pages of info).

Mac