You were right. The encoding of the tables in my database was utf8 but the database itself had the latin1 character set. I have altered the database to the utf8 character set and can confirm that, having done that, the two lines in connection.php did not need to be swapped.
I leave it to yourself and Matthias to figure out whether both of those lines are necessary and in which order they should be - that is beyond my understanding! ;-) Thanks Philip On 20 Jul 2011, at 18:38, Chris Meller wrote: > If switching those two fixes your problem it means that the database you're > using for Habari on your MySQL server is not set to a good encoding (like > UTF8), it's probably using the default latin1 instead. > > > The only time that's a problem is in this exact situation. SET CHARACTER SET > sets the collation for the database connection to whatever is being used by > the database you're talking to. If that's not also utf8 then MySQL butchers > the data and bad things happen. > -- 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-dev
