Can I change the ExpressionEngine DB collation?
How Do I?
one week ago
Any reason EE uses
//'char_set' => 'utf8',
//'dbcollat' => 'utf8_unicode_ci',To add Emoji’s to posts I updated it to
'char_set' => 'utf8mb4',
'dbcollat' => 'utf8mb4_unicode_ci',in ee/ExpressionEngine/Service/Database/DBConfig.php. But it will be wiped on the next upgrade. Is there a way to fix this in user config, or … ?
one week ago
$config[’database’] = array ( ‘expressionengine’ => array ( ‘hostname’ => ‘mysql’, ‘username’ => ”, ‘password’ => ”, ‘database’ => ”, ‘dbdriver’ => ‘mysqli’, ‘dbprefix’ => ‘exp_’, ‘char_set’ => ‘utf8mb4’, ‘dbcollat’ => ‘utf8mb4_unicode_ci’, ‘pconnect’ => FALSE ), );
https://docs.expressionengine.com/latest/config/config.html#database
one week ago
Ha, I was reading too fast. Thank you.