Data type

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
minds_gifts
Forum Commoner
Posts: 63
Joined: Mon Feb 10, 2003 4:23 am

Data type

Post 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
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Post Reply