html output from stored procedure in a variable in servlets getting truncated

Question

hi, i am having a stored procedure in sql server which returns a variable of nvarchar(max) datatype . the value of the variable is a html file contains table. in servlets i am able to get the output value from the stored procedure and store it in a string variable. But when i am printing it then it is getting truncated and some portion of the html file is missing. how to overcome this issue.

thanks in advance.

Answer 1

as for this is concerned i find out the reason, i was using wrong jdbc sql data type , while i was using varchar it is truncating but when i changed that into longvarchar then things got working now.