Sort Swedish characters?

  • Resolved jabbin

    (@jabbin)


    4 years, 12 months ago

    Hi,
    Great plugin!

    If i run the loop with this: [loop type=customers orderby=title]

    I will get the Swedish alphabet in the wrong order.

    “Å” and “Ä” is treated as they were “A”. Any idea how to get this to work?

    The Swedish alphabet:
    ABCDEFGHIJKLMNOPQRSTUVXYZÅÄÖ

Viewing 4 replies - 1 through 4 (of 4 total)
  • polarracing

    (@polarracing)

    4 years, 12 months ago

    Have you checked if the Swedish letters are recognized by [if]?

    If so, there is a workaround.

    1. Create a loop
    2. Use [if] to filter the proper values and put their ids into a [var]
    3. Run another loop and use this list to exclude already presented records.

    In the second loop you now should only get values that are not presented so far – giving you back all Ä, Ö, etc.

    If you need you can do the trick twice to sort out even “Å” and “Ä”

    • This reply was modified 4 years, 12 months ago by polarracing.
    Thread Starter jabbin

    (@jabbin)

    4 years, 11 months ago

    Thank you for the quick response!

    I’m not 100% sure I understand exactly how to accihieve this, but that will be hard with titles that have ÅÄÖ inside the title and not in the beginning?

    Peter Berger

    (@peterpolow)

    4 years, 11 months ago

    Is it possible to change the database settings to get the right order?

    Take a look at this post: https://wordpress.org/support/topic/wrong-order-with-utf-8-swedish-characters/#post-10348656

    Thread Starter jabbin

    (@jabbin)

    4 years, 11 months ago

    Wow, great “utf8mb4_swedish_ci” solved this for me!

    Thanks Peter!

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

The topic ‘Sort Swedish characters?’ is closed to new replies.