title: What is the max length for char type in MySQL?
body: <p>I am trying to convert a BLOB into some text format. So I wrote a query like this, which works fine:</p>
  
  <pre><code>SELECT CAST(key_initiatives AS CHAR(1000) CHARACTER SET utf8 )  AS key_init 
  FROM OBJSETTING_FOCUS_ON_CUSTOMER
  </code></pre>
  
  <p>If I try to create a column with a char type which does not allow more than 250 characters, when the source data allows 1000 or even 15000 characters, what will happen?</p>
  
  <p>I am using MySQL GUI v9.50.</p>