title: What column type does SQLAlchemy use for "Text" on MySQL?
body: <p>My overall use-case is trying to determine whether I can write a somewhat database agnostic (at least supporting Postgres and MySQL) store for some large data as raw text (think ~500MB as a rough theoretical upper bound).</p>
  <p>Based on <a href="https://stackoverflow.com/a/25578637/2540669">this answer</a> about MySQL string/text types, it looks like only the <code>LONGTEXT</code> column type can meet my requirements. I'm using SQLAlchemy, which claims for its <a href="http://docs.sqlalchemy.org/en/latest/core/type_basics.html#sqlalchemy.types.Text" rel="nofollow noreferrer"><code>Text</code></a> column type that it is for variable length strings, but also that it generally maps to the database's <code>CLOB</code> or <code>TEXT</code> types. MySQL doesn't have a <code>CLOB</code> type (though it does have a BLOB), and its <code>TEXT</code> type would be insufficient for my needs.</p>
  <p>So, <em>What column type does SQLAlchemy use for <code>Text</code> on MySQL?</em></p>