Database connection as UTF8 into config.php

Talk about writing modules and plugins for CMS Made Simple, or about specific core functionality. This board is for PHP programmers that are contributing to CMSMS not for site developers
Post Reply
tobik
Translator
Translator
Posts: 149
Joined: Thu Aug 16, 2007 6:18 pm

Database connection as UTF8 into config.php

Post by tobik »

In this post calgay mentioned the use of 'set names utf8' in cmsms 1.1. Anyway, in present releases (1.2 - 1.2.3) this is deactivated in include.php.

But quite often mysql expects utf8 data (see mysql variables: character_set_client, character_set_connection) and this line must be reactivated and again with every update. Otherwise wrong special characters, umlauts etc will be written to the database. Some users will not even notice this until a backup is beeing made and restored on a different server. Only then the wrong special characters will come through to the browser.

Question:
Would it be possible to store this as a property in config.php?

Thanks for considering,
Tobias
Pierre M.

Re: Database connection as UTF8 into config.php

Post by Pierre M. »

Hello,

you should file a feature request in the forge as the devteam may not see or forget your forum post.

Pierre M.
tobik
Translator
Translator
Posts: 149
Joined: Thu Aug 16, 2007 6:18 pm

Re: Database connection as UTF8 into config.php

Post by tobik »

Thats it. Thanks
Post Reply

Return to “Developers Discussion”