Move Complete

Posted by on Sun, January 7, 2007

▼ A d v e r t i s e m e n t

This site has been moved to another hosting server. Some of you might have received an error message from the old server, if your DNS has not been made aware of the server change and still have the old IP address. Sorry for any inconveniences. This is normal for any DNS change.

Additionally, WordPress have been upgraded to 2.0.6

Update: Since my previous hosting uses MySQL 4.0 and the new server uses MySQL 4.1 there seems to be some kind of confusion. Many UTF-8 characters such as the ” character were displayed as ? instead. I spotted this problem when receiving errors from FeedBurner.

A dirty quick fix is to open up /wp-includes/wp-db.php and look for these:

function wpdb($dbuser, $dbpassword, $dbname, $dbhost) {
$this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);
if (!$this->dbh) {

And add an additional line:

function wpdb($dbuser, $dbpassword, $dbname, $dbhost) {
$this->dbh = @mysql_connect($dbhost, $dbuser, $dbpassword);
$this->query("SET NAMES 'utf8'");
if (!$this->dbh) {

I am sure WordPress guys will not agree with this quick hack ;-)

This is due to how MySQL 5.0 handles collations.

I found the fix here: http://blog.jtam.org/…

Related Posts with Thumbnails

Facebook Comment

WARNING & REMINDER: Comments are moderated and there is no exception. Comments unrelated to the post, too short, using phoney emails or funny names, will be marked as spam. Foul languages are filtered as spam. Your email will never be displayed on this site. If you would like to receive replies, use a valid email address and check the subscription box below.
 
  • http://amanz.net aman

    skrang nie pakai dream host ke?

  • http://www.romantika.name ady

    Tak la.. pakai Exa Bytes Malaysia.. tu readme untuk fix je tu kebetulan..

  • http://blog.mypapit.net/ mypapit

    I was faced with the same problem too (although not wordpress related), I only recently found that I’ve to use SET NAMES ‘utf8′, to get around the migration problem