title: PHP/MySQL encoding problems. â�� instead of certain characters
body: <p>I have come across some problems when inputting certain characters into my mysql database using php. What I am doing is submitting user inputted text to a database. I cannot figure out what I need to change to allow any kind of character to be put into the database and printed back out through php as it's suppose to.</p>
  
  <p>My MySQL collation is: latin1_swedish_ci</p>
  
  <p>Just before I send the text to the database from my form I use mysql_real_escape_string() on the data.</p>
  
  <p>Example below</p>
  
  <p>this text:</p>
  
  <pre><code>â��People are just as happy as they make up their minds to be.â��
  â�� Abraham Lincoln 
  </code></pre>
  
  <p>is suppose to look like this:</p>
  
  <pre><code>“People are just as happy as they make up their minds to be.”
  ― Abraham Lincoln
  </code></pre>