On March 26, 2019 we launched new MODX Forums. Please join us at the new MODX Community Forums.
Subscribe: RSS
  • 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.
    • 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"}` ]]