I am trying to change unicode in my phpmyadmin as instructed below: PhPMyAdmin=>Choose your database=>Click your database=>Operations=>Collation=>utf8mb4_unicode_520_ci=>GO. However, I dont have unicode_520 in my dropdown box, can i add this?
Asked
Active
Viewed 62 times
0
-
2Possible duplicate of [How to change the default collation of a database?](http://stackoverflow.com/questions/5906585/how-to-change-the-default-collation-of-a-database) – cmorrissey Dec 07 '16 at 21:44
-
@cmorrissey - I don't think that's an appropriate duplicate. Making the change via PHPMyAdmin's GUI as opposed to writing a query distinguishes this question enough not to close it for that reason. – HPierce Dec 08 '16 at 00:28
-
@HPierce the phpMyAdmin install is controlled by the OPs hosting solution and can not be modified by him (screenshot was removed showing this), which is why I marked this with this solution. – cmorrissey Dec 08 '16 at 14:30
-
Which MySQL version are you using? This should be a factor of your MySQL configuration, not phpMyAdmin itself. – Isaac Bennetch Dec 12 '16 at 16:21