在php中编码一个字符串

Question

I am executing the following statement.

$mystring = <<<EOT
UPDATE sites_niche SET `short_review` = REPLACE(`short_review`, '’',"'");
EOT;

However, it doesnt work, as it would work if I placed it in my phpmyadmin. The culprit is this bad character ’ that character is simply not being replaced.

I tried to print the update statement to the screen and I get this:

UPDATE sites_niche SET `short_review` = REPLACE(`short_review`, '’',"'");

I think that the string gets garbled as soon as it goes to the database. My question is how do encode those sets of characters ’ so that they dont get garbled as soon as they go to the database.

Answer 1

You can use the iconv extension http://es.php.net/manual/en/function.iconv.php or mbstring http://es.php.net/manual/en/function.mb-convert-encoding.php to convert a string from one charset to other charset