title: ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes
body: <p>I was installing Govway 3.3.2 on a linux machine with Tomcat 7.0.76.0 and MariaDB 10.2.23; when I started importing the sql &quot;GovWay.sql&quot; I got the error &quot;ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes&quot;.
  I tried to change the character and I also tried to set the following variables:</p>
  <ul>
  <li>SET GLOBAL innodb_large_prefix=ON;</li>
  <li>SET GLOBAL innodb_file_format=barracuda;</li>
  <li>SET GLOBAL innodb_file_per_table=true;</li>
  </ul>
  <p>but I haven't solved the problem.</p>
  <p>the solutions proposed in this question, it is not possible for me to apply them
  <a href="https://stackoverflow.com/questions/52840560/mysql-error-1071-42000-specified-key-was-too-long-max-key-length-is-3072-byt">question</a></p>
  <p>other solutions said to change the</p>
  <blockquote>
  <p>varchar (4000)</p>
  </blockquote>
  <p>but I can't make this change.</p>
  <p>any suggestions?</p>