title: Is there any way to make a UNIQUE index case insensitive in Mysql 5.1.x ?
body: <p>If so - What must change in this table ?</p>
  
  <pre><code>CREATE TABLE  contestants 
  ( 
    idContestants  int(10) unsigned NOT NULL AUTO_INCREMENT,
    idEvent        int(10) unsigned NOT NULL,
    ContestantName  varchar(50) DEFAULT NULL,
    PRIMARY KEY (idContestants),
    UNIQUE KEY Index_UniqueName (idEvent,ContestantName),
  )
  ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
  </code></pre>