Thanks, Andrew, I don't think in this case it is the browser's
encoding - I'm using Firefox and UTF-8 is checked as the character
encoding, but ...
*A minute or two later*
... 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).
Perhaps someone who understands this better than I might know why
swapping the lines makes a difference, and if there is a good reason
why they should be swapped, perhaps they should be swapped in the core
code?
Philip
On Jul 20, 1:57 am, Andrew Heath <[email protected]> wrote:
> I've successfully used Simplified Chinese on my installation.
>
> Perhaps your browser's encoding is not also set to Unicode?
>
> - A
>
> On Wed, Jul 20, 2011 at 8:52 AM, Philip Buckley
> <[email protected]>wrote:
>
>
>
>
>
>
>
> > If I create a new entry and enter some Russian letters (cutting and
> > pasting from a UTF8 text file or entering them manually), the letters
> > show up correctly in the text area until I click Save, at which point
> > they all turn to question marks.
>
> > I assume there is some problem putting the text into the database /
> > reading it out?
>
> > Habari version is 0.7.1; Database is MySQL; OS is Mac
>
> > Any suggestions how to get round this? Any suggestions how to track
> > down where the problem is arising?
>
> > Thanks
>
> > Philip
>
> > --
> > 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
--
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
