Listing Sorting

This topic contains 9 replies, has 3 voices, and was last updated by  Stiofan O’Connor 8 years, 5 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • October 27, 2015 at 2:57 pm #58139

    Fredrik
    Buyer
    Post count: 67

    Hi,

    The feature to be able to sort the listings alphabetically has recently been added to geodirectory, it works but not with the swedish characters “Å Ä Ö”. Those are classed as “A” and “O” making them appear at the very beginning (Å/Ä) and in the middle of the list (Ö) when they should be at the very end of the list.

    Can I do something to fix this?

    I’ve checked the collations on the SQL server and they are all set to “utf8_swedish_ci”. I have tried several without luck. I’m guessing the GD code for this needs fixing.

    October 27, 2015 at 7:07 pm #58196

    Paolo
    Site Admin
    Post count: 31206

    Hi Frederik,

    I’ll ask to the developers to look into this. I’ve found this information too. http://stackoverflow.com/questions/13706099/mysql-wont-order-by-swedish-characters-%C3%A5%C3%A4%C3%B6-not-working-even-though-collation-is

    They’ll let us know asap.

    Thanks for your patience,

    October 31, 2015 at 3:05 pm #58658

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Fredrik,

    The actual column must be set to “utf8_swedish_ci” the table might be set to “utf8_swedish_ci” but if the column is not set to “utf8_swedish_ci” then it still wont work. I have tested on my local install by ONLY changing the post_deails.post_title to “utf8_swedish_ci” and it then works.

    Let us know if you have any problems.

    Thanks,

    Stiofan

    November 3, 2015 at 8:02 am #58860

    Fredrik
    Buyer
    Post count: 67

    Hello,

    I have actually already tested this but still doesn’t work.

    View post on imgur.com

    View post on imgur.com

    Regards.

    November 3, 2015 at 7:40 pm #58920

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    please provide URL, admin and FTP credentials in a private reply and we will have a look.

    Thanks

    November 3, 2015 at 7:41 pm #58921

    Paolo
    Site Admin
    Post count: 31206

    I almost forgot the most important url and credentials. Those for phpmyadmin.

    Let us know,

    Thanks

    November 4, 2015 at 8:14 am #58968

    Fredrik
    Buyer
    Post count: 67
    This reply has been marked as private.
    November 4, 2015 at 3:22 pm #58997

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi can you link to a page that has the sort option, i searched for about 10 minutes and could not find where you have it.

    Stiofan

    November 23, 2015 at 10:32 am #61180

    Fredrik
    Buyer
    Post count: 67
    This reply has been marked as private.
    November 24, 2015 at 7:15 pm #61402

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hello, the back-end uses the wp_posts table, i have changed the encoding there for you and it now works.

    Thanks,

    Stiofan

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 10 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket