title: mysql error: Specified key was too long; max key length is 767 bytes
body: <p>I had to run this command to alter a column in one of my table.</p>
  
  <p>ALTER table XYZ modify value VARCHAR(1024);</p>
  
  <p>When I run it, I get this error.</p>
  
  <p>ERROR 1071 (42000) at line 1: Specified key was too long; max key length is 767 bytes</p>
  
  <p>The original column size was 250.  Here is the strange part.  I have a 2nd MySQL server with identical configurations and it is doing 2 way replication with the 1st server.  When I run this "alter table" command on my 2nd MySQL server, I didn't get this error.  In fact, after the alter command finished running, this command was replicated to my primary mysql server without any error.</p>
  
  <p>My two mysql servers are setup as active-active, but only one of them is being actively use.  So to clarify, I got this "max key length" error on the actively used server.  But it ran fine on the 2nd server that was not being use.</p>
  
  <p>Does anyone have any idea why the command ran find on my 2nd server?</p>
  
  <p>Thanks../Ken</p>