After to updated PHPMyAdmin the default collation has been set to utf8mb4_general_ci instead the old default collation utf8_general_ci. As I do not have any need to use utf8mb4_general_ci I would like to restore utf8_general_ci as default.

Looking on my database configuration I have this:

default-character-set = utf8 
character-set-server  = utf8 
collation-server      = utf8_general_ci 
character_set_server   = utf8 
collation_server       = utf8_general_ci 

Also I have added these lines to the file config.inc.php in PHPMyAdmin to try to make it work.

$cfg['DefaultCharset'] = 'utf8_general_ci'; 
$cfg['DefaultConnectionCollation'] = 'utf8_general_ci';

However, even when all is set to utf8_general_ci on the config files still I can see on the main page utf8mb4_general_ci as defaul Server connection collation. Is there something it could be done to set the collation to utf8_general_ci instead?

closed as off-topic by HopelessN00b Mar 23 '15 at 20:56

  • This question does not appear to be about server, networking, or related infrastructure administration within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 0 down vote accepted

Using

$cfg['DefaultCharset'] = 'utf8';
$cfg['DefaultConnectionCollation'] = 'utf8_general_ci';

will have the effect of all statements to get the correct charset (notice that right value for "DefaultCharset" is "utf8") and collation, although on start page the "utf8mb4_general_ci" is displayed which might be a "by design" converted value feature in phpMyAdmin.

Not the answer you're looking for? Browse other questions tagged or ask your own question.