title: default database collation not respected while importing
body: <p>In my database, the collation was originally <strong>utf8_general_ci</strong>. However, I noticed that <strong>utf8_unicode_ci</strong> is necessary because of better sorting accuracy.</p>
  
  <p>So I exported all database using phpmyadmin and checked that the word "COLLATION" does not appear in the exported sql file (except for only 2 times in one table where it is set to binary) so generally this script is collation agnostic and should not imply any specific collation when importing but use database default.</p>
  
  <p>After dropping all tables, the database collation was changed to <strong>utf8_unicode_ci</strong> and then the import script was run from phpmyadmin. But as a result, all tables and all columns are shown again with <strong>utf8_general_ci</strong> collation (and sorting is incorrect). Why?? And what to do to change it?</p>
  
  <p>P.S. The export/import script contains commented line at the beginning:</p>
  
  <pre><code>/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  </code></pre>
  
  <p>I don't know if it has any impact while importing, but after opening mysql console, the command <code>show variables like 'collation_connection'</code>shows COLLATION_CONNECTION as <strong>cp852_general_ci</strong>.
  However, in phpmyadmin->variables the variable 'collation_connection' is set to <strong>utf8_general_ci</strong>. But there is no way to change it.</p>