Alphabetical Order Bug

Resolved CookieX
(@cookiex)

7 years, 5 months ago

Hello,

I use this plugin in Swedish and this causes one problem. The plugin use the title name to categorize job categories and job locations in alphabetical order.

The problem is that is in Swedish we have Å/Ä/Ö and it lists these letters as Å/Ä –> A and Ö –> O.

Is there someway to fix this?

Thank you in advance!

Viewing 5 replies - 1 through 5 (of 5 total)

Moderator tobifjellner (Tor-Bjorn “Tobi” Fjellner)
(@tobifjellner)

7 years, 5 months ago
Hi @cookiex
Typically, this depends on which collation you’ve got in your database. So the plugin creates a query that may include instructions about by which field to sort things, but it’s the database that does the heavy lifting in this.

So, google for how to convert the relevant tables to the correct collation. It’s doable, but isn’t totally straightforward. (For instance, if you just change the setting for the whole database, then that will only affect the default values next time you create a new table.)

You’re going to want a collation that includes the keyword “Swedish”. Like UTF8MB4_Swedish_cli… give or take. I didn’t double-check right now.
- This reply was modified 7 years, 5 months ago by tobifjellner (Tor-Bjorn “Tobi” Fjellner).
Plugin Author PressTigers
(@presstigers)

7 years, 5 months ago

Hi @tobifjellner,

Thanks for your response to @cookiex. Hope you had a great WordCamp US. A lot of love & respect from PressTigers side.

@cookiex hope you got the answers to your question now. You can define the collation in the wp-config.php file and manage the things accordingly.

Best Regards,

Thread Starter CookieX
(@cookiex)

7 years, 5 months ago

Thanks to the both of you. I tried the database way with no luck. Going to have a look at the wp-config later today to see if I can make sense of it.

I’ll update this thread later either way.

Thread Starter CookieX
(@cookiex)

7 years, 5 months ago

I’m missing something…

I used this guide to edit the wp-config: https://codex.ww.wp.xz.cn/Editing_wp-config.php#Database_collation

And this guide to edit the database: https://mediatemple.net/community/products/dv/204403914/default-mysql-character-set-and-collation

What am I missing?

Thread Starter CookieX
(@cookiex)

7 years, 5 months ago

Nevermind, finally fixed it! Thank you.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Alphabetical Order Bug’ is closed to new replies.