I am just embarking on a new project, and we have hit a scenario where we need to store more than 8000 characters in the field. Since we have upgradede to SQL 2005 it seems like the ideal opportunity to use VarChar(MAX).
However, i have read a couple of articles on the web saying that Classic ASP cannot handlle any string longer than 8000 characters and so therefore cannot read a string passed from the database if it exceeds this length. Is this true?
Whilst on the subject, in ASP i would setup my output parameters like so
.Parameters.Append .CreateParameter("@chvBody", adVarChar, adParamOutput, 1000)
However, with a MAX field i dont know the length of the output so, do i still declare the datatype as adVarChar, and what do i put as the length?
Thanks in advance