Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Invalid
    • Affects Version/s: 2.3
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Maybe this is not the best place to ask for a feature supported by doctrine. I apologize if I've chosen wrong channel.
      Hi,
      I can't find an easy way to do natural text ordering with QueryBuilder. OrderBy lets us order text, but I want to order including accents and other simbols. For instance, if we have this words:
      Alabama, Boston, Álamo, Cardiff.
      Natural order: Alabama, Álamo, Boston, Cardiff.
      But current Doctrine order: Albama, Boston, Cardiff, Álamo.

      I know that I can create a custom function or use native query, but I think that natural order often occurs. There are DBMS specific functions like TRANSLATE or REPLACE that can help, but I think that doctrine not support them.

      Thank you,
      Sergio.

        Activity

        Hide
        Marco Pivetta added a comment -

        This depends on the collation of your DB/Table/Column, not on Doctrine itself.

        Show
        Marco Pivetta added a comment - This depends on the collation of your DB/Table/Column, not on Doctrine itself.

          People

          • Assignee:
            Marco Pivetta
            Reporter:
            Sergio Pavón Salamanca
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: