Unicode on WordPress..
Trying to type in ‘Marathi‘ (my native Indian Language) here:
मराठी पोस्ट
This wasn’t working for me earlier and I completely scrapped and rebuilt my blog just for this. Before taking such a drastic step, I did basically try some of those “migrate WP db to utf8″ scripts, read scores of documents on the web related to this, tried changing the MySQL db, tables and column collation to utf8 manually, messed around with wp-config.php, but all I got was ????? in the post body (post title was working fine and the values stored in the table were fine too when I checked from phpMyAdmin!).
So finally I made a copy of whatever I wanted from wp-content/ (plugins, themes, gallery) and deleted WordPress, exported all the data from WP tables to SQL, dropped the db, created a new one, installed latest version of WordPress from the actual download (and not from Dreamhost’s One click installs), ran the installation, set the options as they were before, restored plugins, themes and NEXTGen gallery and finally imported the table data one by one taking while into account a couple of dropped fields (wp_posts.post_category and wp_links.link_category) into the new WordPress tables.
And here I am, with UTF8 characters working for me just fine and most of blog is working as desired.. Definitely not a task for the faint-hearted! 