Which SQL collation to use for special characters such as é?
<p>How do I make special characters appear in my PHP page, knowing that I call the content using an SQL query. For example é appears as � and so on for all other special characters.</p>

<p>I'm using a MySQL server. The db collation was set to utf8_unicode_ci, however some attributs of the tables were set to latin1_swedish_ci</p>