daigo.org RSSUpgrading the WordPress installation
I have many WordPress 2.0.1 installations on my computer. I need to upgrade them to 2.2.1… Here is my notes on what I did and what happened. I was able to upgrade this blog to 2.2.1, but I had problem with my Japanese language websites.
OK, so it was a worst case scenario, really. As I already had this problem before, the truncated Japanese problem had resurfaced. last time, I fixed it in some half-hearted way to temporarily avoid the problem (known as “garbage-in, garbage-out” way) and it came back to hurt me real bad. on my site, 348 pretty long postings that I would not like to lose. Looking at config file on WP 2.2.1, those two things are added:
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
Looking at my server,
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
There are some websites that is doing similar to what i am trying to do, like here and here, but I think I am not quite understanding what is going on…
I am so distracted and can’t concentrate. Here are some things on my mind: The application fee for U.S. citizenship went up from $400 to $675 today and I am kicking myself for not beating it (shoulda, coulda, woulda. That was $275 that I could have spend towards iPhone. Just kidding…)… Japan’s election was as expected for many, but I am afraid that it was because of vote to show more on disapproval of Abe and LDP than support for Ozawa and Democratic party. As I have expressed before, I am for this mostly because of the issue of Article 9 (among other things) but I hope can use the opportunity to do some right things… Korean Christian aid workers in Afghanistan is another disturbing news that I have been following (not closely enough I am afraid) and I just hope and pray for the peaceful resolution.
