Hello guys, how are you? I need some help on OJS. I’ve updated the OJS (after a lot of errors and problems) but I’m having troubles with the charset/encoding. Strange characters, the same of a lot of people, like this: “Ãª Ã¡ ÃªÃ Ã” My config.ing.php: ; Default locale locale = en_US ; Client ou…

Hi @PedroMuniz , I don’t remember any config named collation. There was database_charset, which was removed starting from OJS 3.2.0. What are the charset set and collation of the database?

Hello Vitaliy Database Collation are in line 140 from config.inc.php of 3.2.1-2 version. All the database are in utf8_unicode_ci.

[image] PedroMuniz: Database Collation are in line 140 from config.inc.php of 3.2.1-2 version You are right. My bad. [image] PedroMuniz: All the database are in utf8_unicode_ci. This is the collation, and what about the character set? https://dev.mysql.com/doc/refman/8.0/en/charset-da…

Looks like your configuration is OK, probably the data itself is in a wrong encoding. You can try restore the database from a dump, and if is not corrupted there, upgrade once again.

I tried many many times on sandbox and on my server but didn’t work. There’s something more I can try?

Have you tried with the backup that was made before the upgrade (after which the problem occurred)?

Yes, a lot of times. Thanks for your help.

PKP Community Forum

Charset/Encoding problem after update OJS for recent versions

Software Support

Vitaliy December 14, 2020, 11:37am 10

Hmm, the configuration looks OK to me but if data was already misencoded it should be converted back to the proper encoding. There is a related topic: Charset encode confusion - #4 by asmecher as well as similar threads on this forum.