title: Illegal mix of collations for operation 'match'
body: <p>I've got a query like </p>
  
  <pre><code>select txt, unix_timestamp(added), uid, id2, id2_type 
    from sitelog 
    where match (id2, uid, txt) against (? in boolean mode)
  </code></pre>
  
  <p>that return this error:</p>
  
  <pre><code>Illegal mix of collations (latin1_swedish_ci,NUMERIC), (latin1_swedish_ci,NUMERIC), (utf8_unicode_ci,IMPLICIT) for operation 'match'
  </code></pre>
  
  <p>My query:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `sitelog` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `added` datetime NOT NULL,
    `txt` text COLLATE utf8_unicode_ci NOT NULL,
    `uid` int(11) NOT NULL,
    `id2` int(11) NOT NULL,
    `id2_type` char(1) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    KEY `uid` (`uid`),
    KEY `id2` (`id2`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  </code></pre>
  
  <p>MySQL: 5.5.35+dfsg-0+wheezy1
  How does one fix this?</p>