title: Index column size too large. The maximum column size is 767 bytes. - For INT datatype?
body: <p>I am aware innodb imposes a limit on key size, but an INT?</p>
  
  <pre><code>    CREATE TABLE IF NOT EXISTS  `db`.`TAGS` (
  
   `tag_id` INT( 11 ) NOT NULL ,
   `tag_text` VARCHAR( 700 ) NULL ,
   `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
   `xxx_id` INT( 11 ) NOT NULL COMMENT  'This is for ease of reference lookup later',
   `user_id` INT( 11 ) NOT NULL ,
   `TAG_FACT_RELATION_relation_id` INT NOT NULL ,
  PRIMARY KEY (  `tag_id` ) ,
  UNIQUE INDEX  `tag_UNIQUE` (  `tag_text` ASC ) ,
  UNIQUE INDEX  `tag_id_UNIQUE` (  `tag_id` ASC ) ,
  INDEX  `fk_TAGS_TAG_FACT_RELATION1_idx` (  `TAG_FACT_RELATION_relation_id` ASC ) ,
  CONSTRAINT  `fk_TAGS_TAG_FACT_RELATION1` FOREIGN KEY (  `TAG_FACT_RELATION_relation_id` ) REFERENCES  `meepl`.`TAG_FACT_RELATION` (
  `relation_id`
  ) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE = INNODB;
  </code></pre>
  
  <p>There error says:</p>
  
  <pre><code>#1709 - Index column size too large. The maximum column size is 767 bytes. 
  </code></pre>
  
  <p>Any ideas? I have been muching around with data types for ages. </p>