#1273 - Unknown collation: 'utf8mb4_unicode_520_ci'

I had the same issue as all of our servers run older versions of MySQL. This can be solved by running a PHP script. Save this code to a file and run it entering the database name, user and password and it'll change the collation from utf8mb4/utf8mb4_unicode_ci to utf8/utf8_general_ci


<!DOCTYPE html><html><head><title>DB-Convert</title><style>
    body {font-family:"Courier New", Courier, monospace;" }</style></head><body><h1>Convert your Database to utf8_general_ci!</h1><formaction="db-convert.php"method="post">
  dbname: <inputtype="text"name="dbname"><br>
  dbuser: <inputtype="text"name="dbuser"><br>
  dbpass: <inputtype="text"name="dbpassword"><br><inputtype="submit"></form></body></html><?php
if($_POST){
  $dbname = $_POST['dbname'];
  $dbuser = $_POST['dbuser'];
  $dbpassword = $_POST['dbpassword'];

  $con = mysql_connect('localhost',$dbuser,$dbpassword);if(!$con){ echo "Cannot connect to the database ";die();}
  mysql_select_db($dbname);
  $result=mysql_query('show tables');while($tables = mysql_fetch_array($result)){foreach($tables as $key => $value){
           mysql_query("ALTER TABLE $value CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci");}}
  echo "<script>alert('The collation of your database has been successfully changed!');</script>";}?>

هل كانت المقالة مفيدة ؟

 طباعة

اقرأ أيضاً :

How to clear the cache in Firefox, Internet Explorer, Safari and Opera

  \r\n Here are instructions on how to clear your cache in the following browsers \r\n...