collation - Read For Learn

Database with mixed collation (utf8mb4 & utf8_general_ci)

Custom DB_COLLATE (collation) value not working on fresh install?

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

One for the gurus: upgrade to 3.x messed up only filenames with accented chars

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

How to stop WordPress using utf8mb4_unicode_520_ci collation?

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

Default table collation on plugin activation?

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

Please explain how WordPress works with MySQL character set and collation at a low level

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

How to change collation of database, table, column?

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.

#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

You can solve this by finding in your .sql file, and swapping it with

+ More