Hi guys,
usually i setup a database with the following settings:
CREATE DATABASE `check` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
i just downloaded a database from an installation on a live server, and imported it on a local database with the above
settings. later i saw that the database on the live server used a different Character Set and Collation (latin1, latin1_german2_ci)
the downloaded installation was a MODx 0.9.6.3 RC 2, which i upgraded (local) to the current MODx 0.9.6.3 Version, using the advanced upgrade mode without any problems.
TinyMCE’s setting of entity-encoding is set to raw, and since all pages have been saved again, all special characters are now stored in the database unescaped...everything works perfect!
my question is now:
can this lead to any problems later?, or would the biggest (& maybe/hopefully only ) problem of a changed Character Set & Collation be the incorrect display of special characters?
thanks, j
my config.inc.php details:
$database_type = 'mysql';
$database_server = 'localhost';
$database_user = 'root';
$database_password = '';
$database_connection_charset = 'utf8';
$database_connection_method = 'SET CHARACTER SET';
$dbase = '`databasename`';
$table_prefix = 'modx_';
error_reporting(E_ALL & ~E_NOTICE);