title: Table storage engine for <TABLE> doesn't have this option on order by query (ERROR 1031)
body: <blockquote>
    <p>Table storage engine for &lt;TABLE&gt; doesn't have this option.</p>
  </blockquote>
  
  <p>This is the error returned by MySQL on an <code>order by</code> query. The column type is <code>varchar(2000)</code>.</p>
  
  <p>Query:</p>
  
  <pre><code>select * from `dbo.table_1` order by textT;
  </code></pre>
  
  <p>Error returned:</p>
  
  <blockquote>
    <p>ERROR 1031 (HY000): Table storage engine for 'dbo.table_1' doesn't have this option.</p>
  </blockquote>
  
  <p>Why does this happen? And how can I fix it?</p>