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.

Popularity: 17% [?]



2 Comments to “Improve TwitterTool to support international charset better.”

  1. 我blog故我在 » Blog Archive » 一个小修改让TwitterTools更好支持中文了 | July 16th, 2007 at 10:06 pm

    [...] 具体参见:Improve TwitterTool to support international charset better. [...]

  2. Blog Create Myspace Page | February 10th, 2008 at 4:30 pm

    Lj Graphics Investigation…

    Lj Graphics Investigation
    Lj Graphics InvestigationBelow is a short list of free plugins I discovered in this new database that can drive traffic to your blog, sell terrific products, and keep visitors on your site for a while - the perfect monetizatio…

Leave a Comment

Close
E-mail It
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License.