Code LOL

For some foolish reason, the recent upgrades to WordPress 2.8 and 2.7 changes the collation of the database tables.  This results in the removal of special characters like Japanese, Chinese, or Korean.  All your characters would be lost if you upgraded because the collation is  latin1_swedish_ci instead of utf8_general_ci.  You’re lucky if you hadn’t used those characters before, but if you are planning to in the future, you can update your collation to UTF8 by running the following SQL queries in PHPMyAdmin:

ALTER TABLE wp_comments DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE wp_links DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE wp_options DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE wp_postmeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE wp_posts DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE wp_terms DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE wp_term_relationships DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE wp_term_taxonomy DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE wp_usermeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE wp_users DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;