Friday, March 16, 2012

news website

I am going to run an website publishing news and article. I would like to be able to MANAGE articles accoring to their topic and time. I would like to know if :
1) Is there any software to do that work
2) Database can store short text ( at least what I have been working with, less than 60 characterBig Smile [:D]) but is it possible to store the whole article as an entry in database.
3) If both answer to 1 and 2 is NO, what is the common way that website like what I am intending to run would do.
Regards.

umala wrote:

2) Database can store short text ( at least what I have been working with, less than 60 characterBig Smile [:D]) but is it possible to store the whole article as an entry in database.


I'm not sure about software that will do this for you, but you can use a SQL Server database to store your articles depending on the length. Using the varchar datatype you can store anything from 1 to 8000 characters. If your articles will fit within this range, this would be the best solution because you can add columns for both topic and time or date, which you can then sort them through your database query.
Hope this helps somewhat,
smtraber

0 comments:

Post a Comment