UTF8字符显示不正确[重复]

Question

This question already has an answer here:

• UTF-8 all the way through 15 answers

In my mysql database i have string with german umlauts (ä, ö, ü).

I query them with php/mysql and when displayed on my website, they show up like this:

�

I have this html in my website:

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

edit: i have changed all collations to utf8_unicode_ci but the problem still persists

</div>

Answer 1

If you have written html meta tag as charset=UTF-8 and you have set Collation as utf8_unicode_ci character set and its not working then you must use

 mysql_set_charset('utf8');

use this where you have made your connection file, like this:-

    $link = mysql_connect("localhost","root","");
    $db = mysql_select_db('testing');
    mysql_set_charset('utf8');