Database connection as UTF8 into config.php
Posted: Tue Jan 15, 2008 12:49 pm
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
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