Small problem I'm sure with character set

col

Windows XP
MYSQL 4.1
PHP 4

I'm having displaying Chinese characters. I looks fine using PHPMyAdmin, however when I query it from the MySQL command line, or with PHP, it displays "?".

Can anyone help? Your skills and knowledge would be much appreciated as I've been trying to find a solution for a good day now and it is driving me crazy.

Thanks in advance...

Colin

Weedpacket

If I remember rightly, PHPMyAdmin is written in PHP and you view it in your web browser. If that is the case, you could look at the page in your web browser and see what it says about the character set it's been asked to use to display the page.

col

Changing the following line stops the German text from displaying incorrectly too:

Is there a function I need to add during the SQL query or when I display the text with PHP?

This is my simple HTML page before execution:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Untitled Document</title>
</head>

<body><?

include("inc/database.inc");

$db = new Database("localhost", "test", "root", "root");

// u can use Database("host", "database", "user", password"
$sql = "SELECT * FROM character_set";
$db->query($sql);
echo $db->printSQL();

$db->restartResults();

while($db->getRecord())
{
$chinese = html_entity_decode($db->getField("chinese"),ENT_QUOTES,"BIG5");
echo "$chinese<br>"; // displays ??

echo $db->getField("chinese") . "<br>"; // displays ??
echo $db->getField("standard") . " " . $chinese . " " . $db->getField("german") . "<br>";

}

?>
</body>
</html>[/COLOR]

Thanks