String or binary data would be truncated. The statement has been terminated
<p>In my web application,i am storing password in the database using encryption. the password field's datatype is nvarchar(max). Even i enter the 10 character password e.g. '8427484274' then also i am getting the error. I came to know by searching this is the error we get when we try to store the data more then the datatype's capacity..one thing i want to make clear is that i have '=' symbol in my encrypted string...is there any issue with datatype?if so what can be the biggest datatype then varchar(8000),i have tried that also and still getting the error.how to resolve this?</p>
