Messages posted by: sig

After I did a small modification in the file mysql.class.php in the folder lib, all guestbooks have been displaying properly.

In the section function query, I added:

mysql_query("SET NAMES 'UTF8'");

---------------------------------------

function query($query_string) {

mysql_query("SET NAMES 'UTF8'");

$this->result = mysql_query($query_string,$this->conn_id);
if (!$this->result) {
$this->sql_error("Query Error");
}
return $this->result;
}

Moving several guestbooks from 1and1.com to Godaddy, MySQL database tables show ok on godaddy's server after imported database tables.
All foreign characters show properly via phpmyadmin on godaddy's server. But when come to guestbook's index.php, all foreign characters display as QUESTION MARKs (????) instead of correct characters.
I tried to set uft8 in php's language charset, no help. I also test the same backup database on my VPS box, work fine, showing correct characters.
Please help. Thank you.