Hi everyone I was trying to upgrade an OJS 2.4.8.1 database to OJS 3.1.1.4, the original database is encoded as latin1 and latin_swedish_ci. I was doing the upgrading process in my laptop which has Ubuntu 20.04 and MySQL 8.0.21 and I have noticed when a restore the dump file in MySQL some characters are misencoded as ó, á, ñ, Ã, é
.
I have noticed that MySQL 8 use for default utf8mb4 as character set, but the database used was encoded as utf8. I have executed the upgrading process as 5 times and always finished with the following error:
[data: dbscripts/xml/upgrade/3.0.0_update.xml]
ERROR: Upgrade failed: DB: Cannot convert string '\xCE\x95\xCF\x80\xCE\xB9...' from utf8mb3 to latin1
Someone knows how to correct that error? I have tried to convert latin1 data to utf8 and the upgrading process finished successfully, but I have noticed when made some search, this never returns something.
Thanks for your attention.