What's the biggest size of string I can use with SqlDbType?

Question

I'm using C# with ASP.NET, where the codebehind uses a string named wnotes with about 9500 bytes long. (string wnotes = "...")

When I call a stored proc, I pass the string this way:

        spCommand.Parameters.Add("@wnotes", SqlDbType.VarChar, -1).Value = wnotes; 

In the stored proc, it receives wnotes as:

       declare @wnotes varchar(max)

But after processing, I only see about 4000 get into the database.

Any thoughts?

Answer 1

If the stored proc does any string manipulation of the variable @wnotes it may get truncated.

Answer 2

If wnotes column data type is defined as either VARCHAR(MAX) or NVARCHAR(MAX), you should store more than 9500 bytes. Can you please share confirm wnotes column datatype?

Answer 3

From what you both said, I'm going to assume it's something else I missed.
You both sound confident that it's not this implementation, right?

Codebehind:
spCommand.Parameters.Add("@wnotes", SqlDbType.VarChar, -1).Value = wnotes;

Stored Proc:
declare @wnotes varchar(max);

I'll look to see if I overlooked something!

Answer 4

Another thought. How do you know it’s truncated? Maybe the tool is you use to view the data is truncating the data.