max length of string

[Drstein99]

Im declaring a string, for use with mySQL as an insert string. I cant seem to add more than 386 characters to it. Is there a maximum string length or something else I must declare to make strings larger than that size? Please help.

 

[HJB417]

strings can probably be as large as the the amount of memory your cpu can address (usually 4gb).
Definitely post reproduceable code, and make sure youre using sql parameterized statements....none of this noob ad-hoc bs!!!!

 

[IngisKahn]

If youre continually appending/modifing a string you should use Sytem.Text.StringBuilder