title: #1271 - Illegal mix of collations for operation 'UNION'
body: <p>Trying to write a select-union query, but allways getting this error:
  <strong>#1271 - Illegal mix of collations for operation 'UNION'</strong> </p>
  
  <p>Mysql query:</p>
  
  <pre><code>SELECT users.*, offices.name as office_name FROM huilo_daikiri.`users` left outer join offices on (offices.id=users.office_id) where users.id='120'
  union all
  SELECT users.*, offices.name as office_name FROM huilo_laroc.`users` left outer join offices on (offices.id=users.office_id) where users.id='185'
  </code></pre>
  
  <p>When I separate it for 2 SELECTs - it works.</p>
  
  <p>What I'm doing wrong? Thx.</p>