title: Data too long for column in mysql
body: <p>so I was trying to store SHA1 text into a column named &quot;password&quot; which was initially varchar(20) which was definitely less.</p>
  <p>then I changed the size of the password column to varchar(40) and it still gave me the same error.</p>
  <p>I even tried text and long text which should be enough to store 40 characters but still getting the same error.</p>
  <p>some suggestions were to go to the config file and change the mode to &quot;not strict&quot;.
  I wanted to know if there's any other way.
  what am I doing wrong?</p>
  <p>query:</p>
  <p><code>call RegisterUser(&quot;test2&quot;,&quot;EF548F8AC757FAE6146574F365F64957F16D8A17&quot;,&quot;test2&quot;,&quot;test2&quot;,@returncode);</code></p>
  <p>the above query is running fine with small strings.</p>
  <p><a href="https://i.stack.imgur.com/JhLWs.png" rel="nofollow noreferrer">screenshot of query and the error</a></p>