maximum characters for string data type

[JT]

i don't know why i can't find this anywhere but -

what is the maximum number of characters that a string variable can hold - i
initially thought it was 256, but after some testing it seems that it can
hold much more than that..

tia

 

[Mark Schupp]

vbScript uses variants for all variables. For strings a variant points to a
Win32 BSTR which can have 2*31 characters.

I don't know about JScript but I presume it also uses variants and would
have similar behavior.

 

[Aaron [SQL Server MVP]]

Let us know if you reach the limit. You will probably experience server
slowdown / memory chaos long before you have a string big enough to hit an
actual limit. You will probably get a response buffer limit exceeded error,
maybe?