Maximum size of string can be stored in parameter with ParameterType.Text type

By Joe Ye

Got a question about the parameter value size. I would like to store some data into a parameter with type of ParameterType.Text. What’s the maximum size that it can contain?

The maximum length of string that can be store in ParameterType.Text parameter is the maximum value of type System.int. In practice, the length is still limited by specific computer’s available memory.