Displaying Swedish letters ??? in correct order

Hi @joelmellin

Currently, WooCommerce uses the standard ASCII value ordering, which places these letters at the beginning.

However, you can achieve this by using a plugin that supports sorting according to Swedish standards or custom code to modify the query, which is beyond the scope of our support.

Therefore, if you need help with custom development tasks, it’s best to ask for insight related to those on either the WooCommerce Advanced Facebook group or the WooCommerce Community Slack. Many of our developers hang out there and will be able to offer insights into your question. You can also seek help from the following:

• A local web developer
• Codeable.io
• WooExperts

I wish I could help more, but hopefully, this gets you going in the right direction to get the job done.

Hi @joelmellin

We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

This code snipped solved it all:

add_action( ‘init’, function () {
global $wpdb;
$wpdb->query( “
ALTER TABLE $wpdb->posts
MODIFY post_title TEXT COLLATE utf8mb4_swedish_ci
” );
} );

See thread here:

https://github.com/woocommerce/woocommerce/issues/47847

Hi @joelmellin

That’s great to hear! Thanks for sharing the solution with the community! ??