I use SQL7.0 as my database. If i want to store more than 4000 words into database what Datatype i should choose. Because text only contain length of 16 and nvarchar contains length of 4000.
Don't let the Enterprise Manager fool you. This is where "blobs" of data are stored. This is definitely the data type you are looking for.
Here's a snippet from and ADO command object for inserting or updating nText values. <BR><BR> .Parameters.Append .CreateParameter("@bodytext", adVarWChar, adParamInput, 1073741823, sBodyText)