Page 1 of 1

[Solved] Charset problem with upgrade 1.7 -> 1.7.1

Posted: Sun Jun 13, 2010 8:37 pm
by Charles Butcher
I've just tried to upgrade from CMSms 1.7 to 1.7.1. Everything seemed to go well, except that my character set seems to have changed to something that is not UTF-8.

For instance, on the published site a left-double-quote (“) shows up as "“". Using PHPmyAdmin to look inside the database shows that the "curly quotes" don't show up properly there either.

CMSms is set on UTF-8 and everything was previously fine. As far as I can see from PHPmyAdmin, the DB tables identify themselves as UTF-8.

Now restoring from a backup. Any suggestions so that I can get it right next time?

Re: Charset problem with upgrade 1.7 -> 1.7.1

Posted: Sun Jun 13, 2010 9:54 pm
by Peciura
As far as I can see from PHPmyAdmin, the DB tables identify themselves as UTF-8.
The problem is DB server can communicate not in UTF-8 ( usually in Latin1).
Read this thread for some ideas http://forum.cmsmadesimple.org/index.ph ... 578.0.html

Re: [Solved] Charset problem with upgrade 1.7 -> 1.7.1

Posted: Mon Jun 14, 2010 7:54 am
by Charles Butcher
Many thanks for this. I've marked it as solved, and hope that with my limited skills I'll be able to convert the DB in due course. Sorry for not being able to find that thread on my own.

Would it be useful to explain this in the documentation? I know it's not really related to CMSms, but it's important, and it would seem easier to get it right at the start than to have to convert later.