Improve TwitterTool to support international charset better.

Published on Tue 17 Jul 2007 03:07 ( 5 years, 11 months ago)

AlexKing's Twitter tools is a great wordpress-twitter mashup plugin:

Twitter Tools

This plugin creates an integration between your WordPress blog and your Twitter account. Pull your tweets into your blog and create new tweets on blog posts and from within WordPress.

Download | README | SVN Repository

Latest Release: Version 1.0, 2007-05-07.

However this version TwitterTools have some problem in my Chinese blog, all Chinese characters are displayed as "???", that should be an encoding problem.

After I investigate this problem, I found it because my MySQL database's character set is not UTF-8 unicode, so TwitterTools created a table as default charset, that cause the problem. Why wordpress's posts show correct encoding? I looked through wordpress's code, and found that they will force create tables in correct encoding and won't just use default one.

After I pull some code from wordpress's wp-admin/upgrade-schema.php and plugin TwitterTools.php, problem gone! (All previous data in the table remained problem, I just delete that table and re-activate Twitter tool again. NOTE: Deactivate TwitterTools seemed not delete that table, so you need to delete yourself. )

I will email Alexking the update and he may put this changes to his next version, but before he change it, I release an non-official version here:

Download Twitter Tools with better internationalization support.

Search related in web:

Custom Search

Improve TwitterTool to support international charset better.