CMS Made Simple Forums

I have a site that been running for awhile in 1.5.2 and I want to upgrade it. The problem seems to be that common European characters with accent marks get changed. For example:

Høje becomes Høje
Münster becomes Münster

This happens regardless of the version I'm trying to go to. I've tried jumping straight to 1.114 (which otherwise works remarkably well once I change {stylesheet} to {cms_stylesheet}) or take baby steps and try 1.6.8 or 1.7. The default and admin coding are listed as utf-8.

The strange thing is in all cases, the utf-8 character encoding is in its proper place at the top of the page. If I correct a page in the new version and save it, that works OK. So it appears to be something getting scrambled in the upgrade process.

My test system is a mac with PHP 5.3.5, server database version 5.5.9, with Apache/2.0.64 (Unix) PHP/5.3.5 DAV/2. (MAMP 1.9.6.1)

we can't support older versions. but in 1.11.4 try adding:

$config['set_names'] = false;

into the config.php

Well that fixed the problem in my 1.11.4, thanks. My config had it there, but set to true.

I was curious as to why that fixed it, I didn't find much explanation. I did find this comment in the 1.6 config.php file created by the system:

#This is a mysql specific option that is generally defaulted to true. Only
#disable this for backwards compatibility or the use of non utf-8 databases.
$config['set_names'] = true;

Did I need the false because I already had the tables populated with utf8 info? It seems it's something along those lines, I had found this: http://forums.mysql.com/read.php?103,46 ... #msg-47245