I’m having a issue with duplicate keys. For some reason MySQL is saying that:
“Sóifón” is a duplicate key, when it is not (There are NO records with the same key, I’m checked, checked and checked again). The closest to it is “Sóifon”.
I am getting this error from a SQL dump made on a MySQL 5.1.41 server and I am importing it into a MySQL 5.1.37 server (It works if I import it to the 5.1.41 server)
On the server I’m trying to import to I’ve made sure that the database is using utf8 with a default collation of utf8_unicode_ci (This is the server default on the server that made the dump via phpmyadmin but is NOT on the server I’m importing to) but it keeps insisting that Sóifón is a duplicate key to Sóifon when importing via phpMyAdmin.
What is causing this issue?