You only have 1 option here, which by most standards isn’t advised. You have to edit a core WordPress file: wp-db.php The reason is that there are no filters to change these and the code is kinda hard-coded. WordPress checks the availability of collation it selects though. If you need it just enough to setup … Read more
Maybe you should consider option C). Convert all accented characters to normal UTF-8 characters. So EXPRESSÃO.jpg -> EXPRESSAO.jpg I think this would help you a lot, not only when it come sto coding and file systems, but also storing names / references in databases. Update This is a function I use for removing accents. I … Read more
Not using utf8mb4_unicode…. collation and using a utf8 one instead is a security problem. The right answer is to upgrade your sites and DBs so they all use utf8mb4
You’re missing the point that there is collation not only for the DB but as well for tables and even fields. Therefore from your point of view, I assume that your CREATE TABLE statement is “not complete”. Before using SQL statements, please learn the language first. See CREATE TABLE Syntax (MySQL Manual). Especially table_options / … Read more
There are two defines in wp-config.php of WordPress website: define(‘DB_CHARSET’, ‘utf8’); define(‘DB_COLLATE’, ”); There are several things which are most commonly misunderstood. Names of constants in those defines, might suggest that they are related to the database itself. They are not. They are related to tables within the database. Database creation is totally independent from … Read more
You need to either convert each table individually: (this will convert the columns just as well), or export the database with latin1 and import it back with utf8mb4.
You can solve this by finding in your .sql file, and swapping it with