title: Creating a stored procedure: setting the character set and collation
body: <p>When creating a MySQL stored procedure how does one set the character set and collation? The <a href="http://dev.mysql.com/doc/refman/5.5/en/create-procedure.html" rel="noreferrer">MySQL documentation</a> does not provide any examples and to the general syntax is slightly unclear.</p>
  
  <pre><code>mysql&gt; show procedure status\G
  
  *************************** 1. row ***************************
                    Db: MslLandingSequence
                  Name: DeploySkycrane
                  Type: PROCEDURE
               Definer: curiosity@localhost
              Modified: 2012-08-04 00:05:16
               Created: 2011-11-12 00:02:45
         Security_type: DEFINER
               Comment: 
  character_set_client: latin1
  collation_connection: latin1_swedish_ci
    Database Collation: latin1_swedish_ci
  </code></pre>
  
  <p>The last three items should be Unicode. Thanks.</p>