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?
[Solved] Charset problem with upgrade 1.7 -> 1.7.1
-
Charles Butcher
- Forum Members
- Posts: 103
- Joined: Sat Jul 05, 2008 8:25 pm
[Solved] Charset problem with upgrade 1.7 -> 1.7.1
Last edited by Charles Butcher on Mon Jun 14, 2010 7:50 am, edited 1 time in total.
-
Peciura
Re: Charset problem with upgrade 1.7 -> 1.7.1
The problem is DB server can communicate not in UTF-8 ( usually in Latin1).As far as I can see from PHPmyAdmin, the DB tables identify themselves as UTF-8.
Read this thread for some ideas http://forum.cmsmadesimple.org/index.ph ... 578.0.html
-
Charles Butcher
- Forum Members
- Posts: 103
- Joined: Sat Jul 05, 2008 8:25 pm
Re: [Solved] Charset problem with upgrade 1.7 -> 1.7.1
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.
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.
