Where best to store long text data

[achmo]

Hello,

I am building an ASP system for ordering articles online (the articles themselves are not online). Part of the information I need to store for every article is an abstract, which gets to about 1000 characters or less. My question is, where is best to save the abstract information - in text files, which I will read from my asp page, or in the articles table itself (in which case, using what datatype - varchar? ntext?)

Thank you for your help

Yael Achmon

 

[RickCole]

From the information you have supplied I would say in the articles table itself.

If you know you will never go above 1000 characters then use datatype varchar(1000).

If there is a possibility that at some time in the future you may exceed 1000 then go for something lager up to a max varchar of (8000)

Rick.