On 20 July 2011 11:22, Philip Buckley <[email protected]> wrote: > > ... Oh! I've just found this post by Matthias Bauer <http:// > groups.google.com/group/habari-dev/browse_thread/thread/ > 111b719fc097eeec/b4e3d31a8edf8c25?lnk=gst&q=UTF-8#b4e3d31a8edf8c25> > > and his suggestion works for me ... I have swapped lines 31 and 32 of > schema > mysql > connection.php so that they now are: > > $this->exec('SET CHARACTER SET ' . MYSQL_CHAR_SET); > $this->exec('SET NAMES ' . MYSQL_CHAR_SET); > > i.e. the "SET NAMES" line comes after the "SET CHARACTER SET" line. > > I don't know why that makes a difference, and I don't like modifying > system files, but I'm relieved if that proves to be all it takes (I'd > better double-check my testing).
An aside, as I'm no encoding expert, you shouldn't modify the system files, just make a copy and put it in user/classes and modify the copy. Habari will use that instead, and your changes won't get clobbered in an upgrade. Just don't forget it's there :) -- Michael C. Harris, School of CS&IT, RMIT University http://twofishcreative.com/michael/blog IRC: michaeltwofish #habari -- 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
