title: MySQL illegal mix of collations in view
body: <p>I know there are dozens of similar questions to this, but I've tried all sorts of suggestions and nothing works.</p>
  
  <p>I have a database that's set to <code>utf8_unicode_ci</code> and all tables and columns are also set to <code>utf8_unicode_ci</code> (I've checked and double checked).</p>
  
  <p>I've created a view that joins several tables -- my problem is that when I query the view with <code>SHOW FULL COLUMNS</code> it's listing several (all from the same table) as <code>utf8_general_ci</code> -- even though showing the columns from that single table shows them all to be <code>utf8_unicode_ci</code>.</p>
  
  <p>I've also checked that the server and connection are also set to <code>utf8_unicode_ci</code> using <code>SHOW VARIABLES LIKE '%collation'</code></p>
  
  <p>I'm at a loss as to what to try next. Any suggestions?</p>