Hi Czech users have sometimes problems with ordering…

Hi, Czech users have sometimes problems with ordering items by title when first letter contains some accent character and it is probably caused by wrong collation or encoding. I wanted to ask about the right approach here.

In wp-config.php there is by default:

define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');

But database tables are created with following collation:

  • Default WP tables have utf8mb4_unicode_ci
  • Some pluginPlugin A plugin is a piece of software containing a group of functions that can be added to a WordPress website. They can extend functionality or add new features to your WordPress websites. WordPress plugins are written in the PHP programming language and integrate seamlessly with WordPress. These can be free in the WordPress.org Plugin Directory https://wordpress.org/plugins/ or can be cost-based plugin from a third-party tables have utf8_general_ci
  • And other plugin tables have utf8_czech_ci

Is there any explanation why?

In the end I would like to have probably utf8mb4_czech_ci or utf8_czech_ci for new sites. I should probably translate wp-config-sample.php file, but what should I set exactly for DB_COLLATE? utf8mb4_czech_ci or utf8_czech_ci? And DB_CHARSET should stay utf8?

Is there any easy way to migrate old sites from utf8mb4_unicode_ci to utf8mb4_czech_ci?