title: 'String or binary data would be truncated' fix isn't working. What am I doing wrong?
body: <p>So this is an old question that has been asked many times here, but the obvious solution isn't working for me. I have a query that reads:</p>
  
  <pre><code>INSERT Table1
  (
      schoolName
  )
  VALUES
  (
      &lt;cfqueryparam value="#schoolName#" cfsqltype="CF_SQL_VARCHAR" maxlength="50"&gt;
  )
  </code></pre>
  
  <p>When running this query, I was getting back the 'String or binary data would be truncated' error that's been reported here dozens of times. I looked at the 'Design' option for my table and the maxlength for schoolName was 20, while the value I was trying to insert was of length 22. So in what I thought was an easy fix I simply ran:</p>
  
  <pre><code>ALTER TABLE Table1
  ALTER COLUMN schoolName VARCHAR(50)
  </code></pre>
  
  <p>However I ran this query again, and got the same error! Is there anything else I need to do or anything dumb I am missing? Could it be a caching issue? From what I can tell, the error is saying that I'm trying to insert a string with a length larger than the column is set to allow, and therefore one (of the many) solutions is to expand the max column length.</p>