title: Truncating too long varchar when inserting to MySQL via SQLAlchemy
body: <p>I am inserting data to MySQL via SQLAlchemy models. Recently, this app is running against MySQL configured with <code>STRICT_TRANS_TABLES</code> and app fails occasionally because of <em>Data too long for column</em> error.</p>
  
  <p>I know that I can disable <strong>strict</strong> sql_mode for my session (like here <a href="https://stackoverflow.com/questions/18459184/mysql-too-long-varchar-truncation-error-setting">MySQL too long varchar truncation/error setting</a>),</p>
  
  <p>but I was curious if SQLAlchemy can enforce max String() length for column data. Documentation says, the <code>String()</code> length is for <code>CREATE TABLE</code> only. My question:</p>
  
  <ol>
  <li>Is it possible to enforce max length (truncate too long strings) in SQLAlchemy? </li>
  <li>Can I set it <strong>for individual columns</strong> or for all columns in all tables/database only?</li>
  </ol>