Hello,


I am writing a web application that will allow users to save an unknown amount of text to a sql server 2000 database.

What would be the best data type to use. i'm figuring nvarchar migth be useful
as someone may save 2 or 2 thousand characters (or even more). however i'm aware that i'll need to define a limit with an nvarchar.

is there a data type i can use that doesn't need a limit set? what are the advantage of such a data type as opposed to an arbitraily setting an nvarchar(10000).

Performance is also a big consideration for me, what would be the most efficient data type for storing and retrieving this unknown amount of data.

if in the interests of performance i have to set an arbitrary limit, then thats a decision i'll have to live with