SQLTeam.com | Weblogs | Forums

Any way to post 64Kb text to SQL 2008 using Classic ASP


#1

Classic ASP has some serious limitation on the number of bytes that can be passed to a SQL 2008 Stored Proc.

I've got a web app that posts strings up to 64Kb. Is there a way to efficiently pass this to SQL? I'm wondering if I have to make multiple calls.

Sam


#2

What is the type and size of the data column as defined in your ASP code? SQL itself can handle up to 2GB of text data in one operation by using the varchar(max) datatype or 1GB of Unicode text data by using the nvarchar(max) datatype. There was a time when the max string size was 8K. I think that you'll need to adjust your data type in ASP to reflect this larger (max) capability.