Cyrillic displays as ??? ???? in PHP

Question

I'm trying to print values from the database, containing countrylist. One of the fields in this database is cyrilic. My PHP script looks like this:

include_once("db.php");

$query = mysql_query ("SELECT * FROM country");
$row = mysql_fetch_array($query);

do {
    $id = strtolower($row["id"]);
    $value = ($row["runame"]);
    echo $id . " " . $value . '<br/>';
} while ($row = mysql_fetch_array ($query));

The output from this script looks like this:

ad ???????
ae ???????????? ???????? ???????
af ??????????
ag ??????? ? ???????
ai ????????

So, apparently I need to set UTF-8 for this PHP script... somehow... Does anyone know how to do this? Thank you for your time!

Why not change do...while() to while(){} end get rid of the 1-st fetch_array() call? — user4035, Jul 27 '13 at 09:36

score 1 · Accepted Answer · answered Jul 27 '13 at 09:32

1

Try using SET NAMES utf8 after connecting to MySQL:

mysql_query("SET NAMES utf8");

Or if you are using cp1251 in the database, set this encoding.

As the manual says:

SET NAMES indicates what character set the client will use to send SQL statements to the server... It also specifies the character set that the server should use for sending results back to the client.

answered Jul 27 '13 at 09:32

user4035

22,508
11
59
94

"Using mysql_query() to set it (such as SET NAMES utf8) is not recommended." http://www.php.net/manual/en/function.mysql-set-charset.php – Joni Jul 28 '13 at 10:52

Cyrillic displays as ??? ???? in PHP

1 Answers1