Quotation marks from database being echo'd out as diamond question marks in chrome

Question

I am having a strange problem in that when anything from my mysql database is retrieved and echo'd out in a php script the quotation marks in the record are being replaced by diamond shaped question marks in Google Chrome.

My mysql database is set to collation : utf8_general_ci

The part of script that is pulling down the records is as follows :

    <?php
    echo '<div class="testimonialswrapper">';
    // Retrieve Page Content //
     $testimonialssql = <<<SQL
        SELECT *
        FROM `testimonials`
        ORDER BY id DESC
        LIMIT 5
    SQL;

    if(!$resulttestimonials = $db->query($testimonialssql)){
        die('There was an error running the query [' . $db->error . ']');
    }
    while($rowT = $resulttestimonials->fetch_assoc()){
        if ($rowT['company'] == ''){$name = $rowT['name'];}else{$name = $rowT['name'].' - '.$rowT['company'];}
        $from = $rowT['from'];
        $message = $rowT['message'];
        echo '<p class="testititle">'.$name.'</p>';
        echo '<p class="testifrom">'.$from.'</p>';
        echo '<p class="testimessage">'.$message.'</p>';
            }
            echo '</div>';
    ?>

This is included in my index.php which has the following settings :

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

I have tried using htmlenteties and stripslashes and various other things, but still have the same problem.

score 1 · Accepted Answer · edited May 23 '17 at 12:13

1

If you see the UNICODE REPLACEMENT CHARACTER �, that means your browser is trying to read text in a Unicode encoding, but the encountered value is not actually encoded in a valid Unicode encoding and has hence been replaced as undecodable.

This means the data from your database is not actually UTF-8 encoded, as you claim in your meta tag. You likely have curly quotes encoded in Latin-1 there. See UTF-8 all the way through my web application (Apache, MySQL, PHP, …) and Handling Unicode Front To Back In A Web App.

edited May 23 '17 at 12:13

Community

1
1

answered Oct 03 '13 at 09:42

deceze

510,633
85
743
889

Next to the field it says utf8_general_ci and the text is just plain text copy and pasted from their old website into phpmyadmin. – Iain Simpson Oct 03 '13 at 09:54
1

You have not read the linked articles. You're missing the *connection encoding!* – deceze Oct 03 '13 at 09:55
Thanks !, this worked mysqli_set_charset($db, 'utf8'); – Iain Simpson Oct 03 '13 at 09:56

Quotation marks from database being echo'd out as diamond question marks in chrome

1 Answers1