1273 – Unknown collation: utf8mb4_unicode_520_ci

Hi All, 

If you face error like "#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’ in Mysql then please follow the below steps to solve

Open notepad++

1. Search: utf8mb4_unicode_ci Replace utf8_general_ci (Replace All)

2. Search: utf8mb4_unicode_520_ci Replace utf8_general_ci (Replace All)

3. Search: utf8mb4 Replace utf8 (Replace All)

Save and upload sql script to PHP myadmin.

  • mysql
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How to delete a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...

How to rename a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...

How to Create a Database Username in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...

How to create a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...

How to add a user to a database and add privileges?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...