“ - MySQL数据库中字符串前面和末尾的字符

Question

-I've made a select input with options,
-I've given each option a value="something".
The problem is that in the database the submited value appears like "â€somethingâ€", instead of "something".
I've made research and I've putted :

$link= mysql_connect(DB_HOST, DB_USER , DB_PASS);
mysql_set_charset('UTF8',$link);

& already had:

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

In my database the collation is of type:"utf8_unicode_ci" for all columns

What is the problem then ?

Answer 1

Most likely the data in your database was not written there in UTF8. So you are getting a mismatch of encodings.

Relevant SO question here: "’" showing on page instead of " ' "