We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Problem with getResources, order by and norwegian æ, ø, å

    • 24983
    • 59 Posts
    rich Reply #1, 5 years, 7 months ago
    I have a problem with getResources and sortby pagetitle.

    [[!getResources? &parents=`[[*id]]` &tpl=`myRow` &limit=`0` &sortby=`{"pagetitle":"ASC"}` ]]


    The problem is that the norwegian characters æ, ø, å is not sorted correctly (in the alphabet they come after Z: x, y, z, æ, ø, å).

    As it is now the Ø is coming after the O and å is coming after a (instead of coming last).

    I'm using MODx Cloud and the collation of the database is utf8_unicode_ci.

    Thank you.
      • 24983
      • 59 Posts
      rich Reply #2, 5 years, 7 months ago
      I figured it out, the solution was to add 'binary' to the sortby, like this:
      [[!getResources? &parents=`[[*id]]` &tpl=`myRow` &limit=`0` &sortby=`{"binary pagetitle":"ASC"}` ]]