Error: The maximum column size is 767 bytes

Error: The maximum column size is 767 bytes
Index column size too large. The maximum column size is 767 bytes .

How to Fix MySQL Error: The maximum column size is 767 bytes

  1. in the Wamp server program or any other server programs edit file my.ini or my.cnf .
  2. change this line
    innodb-default-row-format=compact
    to
    innodb-default-row-format=dynamic
  3. save changes then restart  program of server .