title: MySQL error: Illegal mix of collations for operation 'UNION'
body: <p>I am Boxonix!</p>
  <p>I am currently making a comment section for my website, and I'm tiny a bit in trouble! This &quot;Illegal mix of collations for operation 'UNION'&quot; pops out when i run this query:</p>
  <pre><code>SELECT *
  FROM comments
  JOIN users ON comments.user_id = users.id
  ORDER BY users.id DESC LIMIT $LIMIT1
  UNION
  SELECT *
  FROM comments
  JOIN videos ON comments.video_id = videos.id
  </code></pre>
  <p>I am already kind a bit confused, I'm not using MySQL that often!<br />
  Please help!</p>