I need help with accents in text.
A client of mine just changed hosting, but now I'm having problems with accented texts; for example, if there is "umidità" in the text in the database table, it shows up as "umiditÃ" on the website, and so for all other accents.
On the database configuration file is set: $MyConn->set_charset('utf8');
On the previous hosting, everything worked correctly but not anymore.
I noticed that the encoding of the tables in the database is switched from the previous one:
Default Character Set: utf8
Default Collation: utf8_general_ci
To this new encoding:
Default Character Set: utf8mb3
Default Collation: utf8mb3_general_ci
For your knowledge, I have applied to the file "rsobj.php" what is reported in this ticket ($this->Prepared = false;):
https://www.webassist.com/forums/posts.php?id=41498
However, accents did not work even before with "true."
Any ideas on how to solve this problem?
Thank you.