I've run into this problem before moving my database from one environment to another and a colleague helped me make some necessary config changes to MYSQL. It's happening again and I did not document how to fix this.
Problem is that I'm trying to upload the database on the remote server and I'm getting a Mysql error: "ERROR 1709 (HY000) at line 166: Index column size too large. The maximum column size is 767 bytes." Any help would be appreciated.
This has to do with MySQL Database 4-byte UTF-8 support (see Status report for your site). More info: