title: Change MySQL stored procedure 'Database Collation' name
body: <p>I have imported a DB from Local machine to server machine. While importing the Database, the character set values of the DB are set by system default to "Latin". I have changed the character set to "<code>utf8</code>" for the Database. But, the stored procedure of Database collation values are not modified. Currently it is "<code>latin1_swedish_ci</code>". How to change the Database collation values from "<code>latin1_swedish_ci</code>" to "<code>utf8_general_ci</code>" for all the stored procedures.</p>
  
  <pre><code>SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME
  FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = DB_Name;
  
  USE DB_Name;
  ALTER DATABASE DB_Name
  DEFAULT CHARACTER SET = utf8
  DEFAULT COLLATE=utf8_general_ci;
  
  SET NAMES UTF8;
  </code></pre>
  
  <p>Thanks in advance.</p>