Data type

[chinni_77]

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

[andrin]

I think it would not hurt ;-)

[chinni_77]

Thanks andrin.

Any other ideas??

[xblue]

max size of varchar is 255 characters as far as I remember. so, obviously the change would make sense if the average length of keywords exceeded 2.55 letters (which seems rather likely to me, but I don't know your application), right?