Sounds like you're using 0.5.2. There have been several database-encoding related changes in the code since that release. Unfortunately, I don't think the WordPress importer works in the latest SVN either, so you're stuck between a rock and a hard place. You can try converting all your tables to utf8 manually. I find the easiest way to do that is to set the database encoding to utf8_unicode_ci before installing Habari - the tables will inherit that encoding. You can do this through phpMyAdmin by navigating to the database and clicking the Operations tab - it should be the last item on the page. After that, you should be able to install Habari and import without a problem.
If that doesn't work, you can run a query for each table to update them manually, then import. Substitute your own prefix (assuming it's not habari__) in the queries below and dump them in the phpMyAdmin SQL window for your database: ALTER TABLE habari__posts CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__postinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__posttype CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__poststatus CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__options CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__users CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__userinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__tags CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__tag2post CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__comments CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__commentinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__rewrite_rules CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__crontab CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__log CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__log_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__permissions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__users_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__groups_permissions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE habari__sessions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; Good luck and let us know how it goes. Hopefully 0.6 will be out soon and people won't have these kinds of problems anymore. :) On Mon, Jan 26, 2009 at 6:59 AM, HenrikWL <[email protected]> wrote: > > I'm having some issues when porting my blog from WP to Habari. All the > posts get imported ok, but all special characters ends up like > question marks. It's obviously some encoding issue, but I don't know > how to fix it. The WP database is all in utf8_general_ci, but I notice > that the Habari database is all in latin1_swedish_ci. May this be the > culprit, perchance? > > Oh, this is double-posted here and in the forums. This group is more > active than the forums, so I guessed I had better luck here. :) > > > > --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/habari-users -~----------~----~----~----~------~----~------~--~---
