I will admit that I don't know much about variable length strings. I have a variable in a database defined as nvarchar 40, and I am setting the parameter in my vb.net program the same way. However, it is receiving all 40 characters. I thought the purpose of variable length strings was that it would receive the string as only the length of the characters. For instance, I thought Chicago would be received as "Chicago" and not "Chicago + 33 spaces". Am I wrong?
Last edited: