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)
characters wrong after upgrade
-
calguy1000
- Support Guru
- Posts: 8169
- Joined: Tue Oct 19, 2004 6:44 pm
Re: characters wrong after upgrade
we can't support older versions. but in 1.11.4 try adding:
$config['set_names'] = false;
into the config.php
$config['set_names'] = false;
into the config.php
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Re: characters wrong after upgrade
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
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
