title: COLLATE=utf8_unicode_ci getting removed from schema.rb after migrate
body: <p>Running rails 5.0.2</p>
  
  <p>The tables in our schema.rb in source control seem to mostly have the format: </p>
  
  <pre><code>create_table "app_files", 
      force: :cascade, 
      options: "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci" 
  do |t|
  </code></pre>
  
  <p>Note the <code>COLLATE=utf8_unicode_ci"</code> at the end.</p>
  
  <p>When I run migrations the generated <code>schemaa.rb</code> is mostly the same but chops off <code>COLLATE=utf8_unicode_ci"</code> from those lines so it now looks like:</p>
  
  <pre><code>create_table "app_files", 
      force: :cascade, 
      options: "ENGINE=InnoDB DEFAULT CHARSET=utf8" 
  do |t|
  </code></pre>
  
  <p>Based on other SO posts I've tried two things to fix this</p>
  
  <p>1) in my <code>/etc/mysql/my.cnf</code>, I added:</p>
  
  <pre><code>[mysqld]
  character-set-server  = utf8
  collation-server = utf8_unicode_ci
  </code></pre>
  
  <p>2) in my <code>database.yml</code> ive added <code>collation: utf8_general_ci</code> to all of the relevant environments</p>
  
  <p>I then restarted mysql, dropped, created and migrated my db but still the collate line disappears.</p>
  
  <p>Any thoughts on what configuration I need to change to have that bit autogenerated ?</p>