If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Foreign chars showing question marks after moving  XML
Forum Index » Advanced Guestbook Forum
Author Message
sig
Newbie

Joined: 17/07/2009 16:54:53
Messages: 2
Offline

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.
sig
Newbie

Joined: 17/07/2009 16:54:53
Messages: 2
Offline

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;
}
 
Forum Index » Advanced Guestbook Forum
Go to:   
Based on the open source JForum