Alphabetical sorting – local language

I managed to make it work:

In wpconfig.php file I set

define('DB_COLLATE', 'utf8_croatian_ci');

Do an SQL query on database in PhpMyadmin with:

ALTER TABLE wp_posts CONVERT TO CHARACTER SET utf8 COLLATE utf8_croatian_ci

I tried setting with utf8_unicode_ci first, sorting was slightly better but not quite accurate.

Leave a Comment