title: Change database variable "character_set_client" in MySQL
body: <p>I found out in my MySQL I have different global and database "character_set_client" variable. <code>show variables</code> shows </p>
  
  <pre><code>character_set_client | utf8
  </code></pre>
  
  <p>while <code>show global variables</code> shows</p>
  
  <pre><code>character_set_client | latin1
  </code></pre>
  
  <p>I believe the first one is database setting. How can I change it? When I do</p>
  
  <pre><code>set character_set_client='latin1'
  </code></pre>
  
  <p>it is changed only for session. When I disconnect and connect again it is set back to 'utf8'. How can I change it so that it stays at 'latin1'?</p>