This entry was posted on Saturday, March 15th, 2008 at 9:37 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed.
Both comments and pings are currently closed.
One Response to “moved from livejournal to WordPress”
By default, Fantastico created the database with swedish (latin1_swedish_ci) collate and all tables/columns has the same collation. But correct value is UTF-8 (utf8_general_ci)
So I manually in phpMyAdmin changed the collation for every table (and columns too!), deleted all corrupted posts and loaded from my local archive (saved from livejournal) again
Fixed issue for non-latin strings in post.
By default, Fantastico created the database with swedish (latin1_swedish_ci) collate and all tables/columns has the same collation. But correct value is UTF-8 (utf8_general_ci)
So I manually in phpMyAdmin changed the collation for every table (and columns too!), deleted all corrupted posts and loaded from my local archive (saved from livejournal) again
Now works well.