Hi everybody,

We have the following code which is wrong:

if (SqlDbType.VarBinary == parameterType || SqlDbType.Image == parameterType || SqlDbType.Binary == parameterType)
            {
                parameter = new SqlParameter("@" + parameterName, parameterType, parameterValue.Length);

                // TODO: Performance test these two methods
                //byte[] bytes = new byte[parameterValue.Length * sizeof(char)];
                //System.Buffer.BlockCopy(parameterValue.ToCharArray(), 0, bytes, 0, bytes.Length);
                //parameter.Value = bytes;

                parameter.Value = Encoding.UTF7.GetBytes(parameterValue);
            }

The value is being passed as binary string. Do you know what should be the code to pass this info into the DB?

Thanks in advance.