title: How to change collation of all rows from latin1_swedish_ci to utf8_unicode_ci?
body: <p>I ignorantly used the default latin1_swedish_ci character encoding for all of the varchar rows in my database during development and I've determined that this is the root of the character encoding problems I've been having.  In addition to that, it seems like most people these days are recommending that utf8_unicode_ci be used.</p>
  
  <p>I'd like to convert the character encoding for all rows in my database from latin1_swedish_ci to utf8_unicode_ci, but the only way I know how to do is is change it row-by-row in phpMyAdmin, which is really time consuming.</p>
  
  <p>Is there a faster way, such as a query that can be run that changes the collation of all varchar/text rows from latin1_swedish_ci to utf8_unicode_ci?</p>