Want To Learn More About Flipping Domains For Profit: Read My Post On Domain Flipping!

HyperDB And Strange Characters

Posted on August 24th, 2010 by admin in Domain Development | No Comments »

A website I administer loads data from two wordpress databases – a method I recently blogged about – and it ran fine under WordPress 2.9.2.

However, having updated the core to WordPress 3.0.1 I suddenly faced a problem where certain utf-8 characters were coming out all mushy when loaded from the “other” database – even though all the collation and character encoding was done correctly both in the database, database tables and in the output html.

After a lot of hitting my head against the wall I figured out that I had to manually set the wpdb charset to my default charset DB_CHARSET as follows before doing any operations on the “other” WordPress database (this seems to be because the hyperdb plugin underwent a revamp recently and perhaps some stuff was overlooked?):

$wpdb->charset = DB_CHARSET;

This did the trick and the weird characters were gone.

Want to earn a regular income from domain flipping? Watch this VIDEO!

Explore other similar posts that might interest you

Click on a post title to read the post!

• Top 10 CSS Galleries For Inspiration

• 5 On Page SEO Tips

• Premium WordPress Themes From ThemeForest

• Converting Website Visitors Into Customers

• 10 Free Premium WordPress Themes In 2011

• Essential WordPress Plugins

• 10 Simple Yet Beautiful Website Designs

• Is Your Website SEO Optimized For Your Target Keywords?

• Multiply Newsletter Signups With This Plugin

• Getting Free Traffic And Backlinks With Article Writing