Sort by post title, wrong order with swedish characters

  • Hi,

    When I choose Sort by Post Title, it sorts the Swedish characters “?” and “?” as “A”, and “?” as “O”. This is messing up the order since ?, ?, and ? is last in the Swedish alphabet. So how can I get it to work with Swedish characters?

    See https://test.glimtenigrytan.se/recept/ where the second post in the list should be in the end of that category.

    Regards,

    Tomas

Viewing 1 replies (of 1 total)
  • alanmroczek

    (@alanmroczek)

    You have to change in your database settings for each table encoding to utf8_swedish_ci instead of (probably) utf8_general_ci. WordPress is using ORDER BY clause, and SQL engine is handling ordering, not wordpress.

Viewing 1 replies (of 1 total)
  • The topic ‘Sort by post title, wrong order with swedish characters’ is closed to new replies.

Tags