title: MySQL error: The maximum column size is 767 bytes
body: <p>When I run a program which does something with MySQL, I got this error message:</p>
  <blockquote>
  <p>2015-06-10 15:41:12,250 ERROR app.wsutils 419 INCRON: Error: ('HY000',
  '[HY000] [MySQL][ODBC 5.2(w) Driver][mysqld-5.7.7-rc-log]Index column
  size too large. The maximum column size is 767 bytes. (1709)
  (SQLExecDirectW)')</p>
  </blockquote>
  <p>I Googled a little bit and found this error might be related to the <code>innodb_large_prefix</code> option. However, I am using MySQL 5.7.7 RC, which has already set <code>innodb_large_prefix</code> to be &quot;ON&quot; (checked in MySQL Workbench), allowing up to 3072 bytes. I am not sure if that is the problem with <code>innodb_large_prefix</code> or not.</p>
  <p>Anyway, does anyone have an idea how to fix this problem?</p>