[OJS 3.3.0.8] Error encoding character after Upgrade to OJS 3.3.0.8

Hi everybody,
I would need help to solve this font problem, I have several jobs that have wrong letters like: ’ or [“do you have any idea how to correct this error?

I have the setting like this:

;;;;;;;;;;;;;;;;;;;;;
Database Settings ;
;;;;;;;;;;;;;;;;;;;;;

; Database collation
collation = utf8_general_ci

;;;;;;;;;;;;;;;;;;;;;;;;;
Localization Settings ;
;;;;;;;;;;;;;;;;;;;;;;;;;

; Client output/input character set
client_charset = utf-8

Database connection character set
connection_charset = utf8

Thanks for every support.
Bye
Tiziano

Hi @Tiziano ,

did you check the collation at your database? Are you actually using utf8_general_ci on every table?

Hi @gonzalognzl, yes every table has utf8_general_ci

Hi Tiziano,

Try the following:

Login to your installation database

$ mysql your-database -u your-database-user -p

Run this query to check your character set:

mysql> SELECT TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'your-database' AND COLLATION_NAME IS NOT NULL AND COLLATION_NAME != 'utf8_general_ci';

If the above query returns any tables with collations that are not ‘utf8_general_ci’ these collations will need to be converted to ‘utf8_general_ci’

mysql> ALTER TABLE <table_name> CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Please let me know if you need any further assistance.

Best regards,

Josh Noronha (he/his)
Systems Specialist
PKP|PS Support Team

Subscribe to the PS Bulletin for quarterly updates on
PKP software, support, and community events

Hi @jnoronha , thanks for your help, I followed your advice, but I was sure that all the tables were in utf8_general_ci, I confirm that, I still need your help to solve this that looks like an upgrade bug, because, we have many journals with OJS, and for others when I upgraded to version 3.3.0.8 they did not have this result, all the characters are correct, I could not tell the difference.

Bye
Tiziano

Hi @Tiziano,
did you check database-collation as well? There is not only a collation for each table, but for the database as a whole.
(Gabriele)

Hi @ojs_univie, yes, all the database has the same collation. :slight_smile:

Bye
Tiziano

When you write “all the database” it still sounds to me like you are referring to the tables. Here’s an SQL-query of what I mean:

USE db_name;
SELECT @@character_set_database, @@collation_database;

edit: source MySQL :: MySQL 8.0 Reference Manual :: 10.3.3 Database Character Set and Collation
(Gabriele)

Yes, I ran the command, and here is the result:

Schermata 2021-11-30 alle 13.32.58

What do the broken characters look like in the database? Are they okay there? Which jobs are affected?
(Gabriele)