Topic on Project:Support desk

When I'm using localhost/phpmyadmin, it displays, "#1273 - Unknown collation: 'utf8mb4_unicode_ci' ". How can I solve the problem?

I only found the problem in localhost/phpmyadmin. I didn't find any questions in installing wamp5 1.7.4. But using localhost/phpmyadmin is important.

Error 1273 means that your database is using a collation, which the MySQL server does not understand. This can happen, when you use a database, which has been created with a newer version of MySQL, with an older MySQL server version. This problem can be solved by converting the wrong collations from utf8mb4_unicode_ci to utf8_general_ci. There is a script on stackoverflow, which does exactly that.

"Error 1273 means that your database is using a collation, which the MySQL server does not understand. This can happen, when you use a database, which has been created with a newer version of MySQL, with an older MySQL server version. This problem can be solved by converting the wrong collations from utf8mb4_unicode_ci to utf8_general_ci. There is a script on stackoverflow, which does exactly that."

--> can you hepl me about link script on stackoverflow?

thanks!

I found sth in other sites:"方法一：替换编码：使用代码编辑器打开导出的sql数据文件，先查找：utf8mb4_unicode_ci，替换为：utf8_general_ci，再查找，utf8mb4，替换为，utf8。方法二：把网站要用的mysql数据库升级到5.5.3以上版本。"[1] But do you know what "sql数据文件"(maybe means "sql data file") means?

1. ↑ http://www.boke8.net/wordpress-mysql-1273-error.html

hello i am amin to fix this error replace all of utf8mb4_unicode_520_ci to utf8mb4_general_ci

It worked..

thanksss

version mismatch

yes its works fine.thanks

MySQL said:

 

#1273 - Unknown collation: 'utf8mb4_persian_ci'

i have this problem when i want to go to phpmyadmin in localhost server i couldn't solve that, can you help me to solve it?

Which steps mentioned above did you already perform, and what was the result?

Here is a complete solution of this problem

https://www.youtube.com/watch?v=_F48w9Fborw

Here is the solution in 4 steps / Solución en 4 pasos:

https://www.diariodeunprogramador.net/importacion-error-1273-unknown-collation-utf8mb4_unicode_ci/