[fixed] Problem with accented characters on document titles

I have a problem with accented characters (scandic characters ä, ö, å) on document titles.

If I make a new document and save it everything seems to be ok. But if I edit the same document and save it, all accented characters on document title will transform to unwanted characters. For example "ä" will transform to "ä"" and so on.

MODx 0.9.6.2
- Default installation => Manager configuration, Character encoding: utf-8

MODx config-inc.php
- $database_connection_charset = ’utf8’;
- $database_connection_method = ’SET CHARACTER SET’;

Database
- DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

XAMPP for Windows 1.6.0a
- Apache 2.2.4
- MySQL 5.0.33
- PHP 5.2.1

On same environment MODx 0.9.6.1p2 works just fine.

Does anyone else have same kind of problems or do I have a problem with my XAMPP configuration?

I think you need this patch.
http://svn.modxcms.com/jira/secure/attachment/10113/set-character-set_set-names_0.9.6_branch_bugfix_1.patch

Quote from: tkfm at Sep 17, 2008, 09:41 AM

I think you need this patch.
http://svn.modxcms.com/jira/secure/attachment/10113/set-character-set_set-names_0.9.6_branch_bugfix_1.patch

Thank you very much pointing me to the right direction. I have only vague understanding what this patch does but it really seems to cure all my problems with accented characters. I also noticed that same problem is discussed here.

I had been waiting for this patch, thanks a lot for the link !

After further investigation I have found that in my case all I need is actually this fix:

manager\includes\extenders\dbapi.mysql.class.inc.php line 80

Add before line "global $modx;"



This brings back my accented characters on document titles.

The problem is not limited to titles but to pretty much all texts.
Happily, adding that
global $database_connection_method;
as explained above is all I needed to fix all accented letters issues in a freshly updated (0.9.6.2) site.

Can you provide a complete list of all files and line numbers that need this patch in Jira, please?

Quote from: rthrash at Sep 18, 2008, 09:46 PM

Can you provide a complete list of all files and line numbers that need this patch in Jira, please?

As I understand this problem is already taken care of as a part of this larger patch in Jira: http://svn.modxcms.com/jira/browse/MODX-185

Thanks
If not fix the bug, the site can work exactly only when you creat a new doc.

Quote from: tkfm at Sep 17, 2008, 09:41 AM

I think you need this patch.
http://svn.modxcms.com/jira/secure/attachment/10113/set-character-set_set-names_0.9.6_branch_bugfix_1.patch

How do I use such a patch?

Martin