What data type to use? 1

[edgarasm]

What data type should I use in order to held a lot data.
Is there some data type which let me held an ilimited amount of data?

 

[fluteplr]

Text if it is character data.
Image if it is binary data.

How much is a lot.

You might also want to look at varchar it can hold up to 8000 characters.

 

[edgarasm]

you asked me how much is a lot.

How about a big text with much more than 8000 characters?

If you have some suggestion, thanks in advance!

 

[SQLSister]

Then use Text or ntext depending on whether you need to store unicode data.

You will also need to learn to handle this kind of data becasue it is not like using the other data types. You'll need t read about WRITETEXT and UPDATETEXT in books online.