title: Why is MySQL ignoring the data type length for a column?
body: <p>I am using MySQL 8.0 and I am trying to store a URL in a column. Every time I try to insert a URL longer than 191 characters, I get the following error:</p>
  <pre><code>1406 Data too long for column 'url' at row 1
  </code></pre>
  <p>The column data type is VARCHAR(1000) and the URL is ~450 characters. I have tried inserting other strings and anything 191 characters and under works fine but nothing does over 191 chars.</p>
  <p>I have tried changing the datatype for this column to other string formats like TEXT, LONGTEXT, and BLOB. I have also tried inserting strings over 191 characters in other tables and they are also limited to 191 characters.</p>
  <p>I know utf8mb4 causes VARCHAR(255) to actually be 191 but I shouldn't it be possible to override that with VARCHAR(1000)? Is there a setting in the database that can cause this issue?</p>